Qlik: Usability Question

[#1]

Hi,

I have a straight table where I have some values listed and I have some filters in the dashboard. I want to be able to filter the data but still show all the dimensional records on the straight table and the expression values can change to NA or 0.

Is this even possible?

** I have tried using show all values option but that doesn't help when a filter is applied.

[vincent_ardiet · Accepted solution]

Hi,

You can do this with the help of the set analysis.

For example, you have a dimension Customer and you want the amount of Sales. Put Customer in the dimension and create 2 expressions:

> First one is: sum({<Customer=>} Sales)

> Second one is: sum(Sales)

Then in the presentation sheet, hide the second column (first expression). You will have 0 in the unselected customers rows.

If you want to put NA, without using a IF which is time consuming, you can try a trick like this in the second expression:

sum({<Customer=>} Sales)*sum({<Customer=>} Sales)/sum(Sales)

It will create a division by 0 for the unselected rows. Then in the presentation sheet, in the "Null Symbol" field type "NA".

Regards,

Vincent