topic Re: how to create a collapsable column in QlikView

how to create a collapsable column

Thu, 12 Feb 2015 10:04:22 GMT

hi,

i would like to make one of the dimension columns in the table collapsable, so if in the sales table i have a country column and a client column, i want the client column to be collapsable so the user is able to see total sales per country if they wanted to, without the sales splitting into the different clients in each country.

Re: how to create a collapsable column

alexandros17 — Thu, 12 Feb 2015 10:06:02 GMT

You can use a Pivot table or you can declare a variable and use it (Setting the variable with a button) in the conditional visualization of the column

Let me know

Re: how to create a collapsable column

Thu, 12 Feb 2015 10:08:15 GMT

Hi,

Create a pivot table with country and client as dimension and sum of sales as expression.

Warm Regards,

Joshmi