topic Re: show only specific dimension values in QlikView

show only specific dimension values

surajap123 — Wed, 21 May 2014 13:45:11 GMT

Hi All,

In a straight table, i have below dimension and expression. I dont want to show all the salesperson by their sales in the table. But only specific salespersons out of 100s.

Dimension--> salesperson

Expression-->sum(sales)

So, how can i show only specific dimension values in the straight table with its corresponding expression result.

Regards,

Suraj

Re: show only specific dimension values

Gysbert_Wassenaar — Wed, 21 May 2014 13:49:10 GMT

Use an expression like this: sum({<salesperson={'Tom','Dick','Harry'}>}sales). The result is that the sum of sales is only shown for the salespersons Tom, Dick and Harry.

Re: show only specific dimension values

Wed, 21 May 2014 13:49:57 GMT

What kind of specific values would you like to show?

Re: show only specific dimension values

Wed, 21 May 2014 13:50:10 GMT

Use a Calculated Dimension instead of salesperson dimension.

ex.

if(salesperson<>'XXX',salesperson)

and check suppress when value is null.

Re: show only specific dimension values

timmarsh — Thu, 13 Aug 2020 05:06:10 GMT

This worked perfectly for me, thanks.