Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional display of dimension items without selecting them

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

1 Reply
Not applicable
Author

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