topic Re: Displaying Table data without list box selection in QlikView

Displaying Table data without list box selection

Wed, 15 Oct 2014 13:42:50 GMT

Hi All,

I have two fields with 0,1 values and one straight table with 50 k records.

let

Field A

-------

I want to display the straight table values where field value =0,

but I don't want to take the fields as list box to made selections.

Without list box selection how we can display the table data where Field value =0

Thanks in advance

anbu1984 — Wed, 15 Oct 2014 13:47:48 GMT

You can use calculated dimension

If(FieldA=0,Dimension)

Then select "Suppress When value is Null"

maleksafa — Wed, 15 Oct 2014 13:58:26 GMT

use if condition like if(FieldA=0, put the dimension name here) or include it in your set analysis for the expressions.

example:

suppose you have 10 dimensions and one expression which is sum(sales), modify it to be sum({<FieldA=0>}sales)