Where Condition in Webi

[Former Member]

Hi

  As per requirement, i created a variable with WHERE condition on it.

Like below,

=[Status] where ([Flag]=1). It produces the result with one empty row. How to get ride of that empty row? I am trying to use this variable in column chart.

Thanks

Hari

[Former Member]

Dear Hari,

As per my understanding if your output is fine and you want to remove only empty row then uncheck the option in graph/table properties "Show when row value is empty" or the problem is with where condition please provide some example with snapshot.

Thanks & Regards,

Ragoth.C

[arijit_das]

Why can't you simply apply a block level filter as Flag = 1 ?

[Former Member]

Actually, i don't want to use report level or block level filters because am using target count which is nothing but both flag 1 and 0. If i apply filter in report level then getting less value

[Former Member]

Got to get in variable level itself?

[Former Member]

what is your actual requirement?

Can you please show us your report snapshot and what you required exactly.

It will help us.

Thanks,

Swapnil

[arijit_das]

Probably you are looking for:

=Count([Status] where ([Flag]=1))

[amitrathi239]

Hi,

Use this.

Var=if(isnull([Status] where ([Flag]=1)) or ([Status] where ([Flag]=1)="") then "Hide" else [Status] where ([Flag]=1)

Apply the report filter and condition is Var not equal to Hide and then turn to chart.

Amit