topic conditional display of dimension items without selecting them in QlikView

conditional display of dimension items without selecting them

Fri, 18 Sep 2009 11:24:08 GMT

Hi,

I want to be able to only see certain customer numbers but I dont want to select them.

So if I had 3 customers A, B and C if I only want to see customer C I could just select customer C but it will flow through all reports and also effect totals, formulas etc

I want to tell the chart to only show certain customers so that the non selected customers are still there just invisible and the totals arent affected

Thanks

David

conditional display of dimension items without selecting them

Fri, 18 Sep 2009 13:26:00 GMT

Guess, you want to display only some particular customers, without selecting that customers manually through QlikView.

It can be done using putting if conditons in the expression

ie, if you are displaying Customers vs Sales, then the sales expression should be:

if(Customer='A',sum(Sales),0)

Suppress Zero Values (Checked)

This way the chart will only display Customer A