topic Re: filter pivot table in QlikView

filter pivot table

andrew001 — Sat, 08 Dec 2012 16:01:06 GMT

I'd like to create a pivot table and show only the alphanumeric ID (indipendent by tha selection)

Thanks

tab1:
load *

inline
[ID
012
012
012
014
014
016
018
018

AAA,

BBB]

;

Gysbert_Wassenaar — Sat, 08 Dec 2012 16:40:30 GMT

Try a calculated dimension if(not isnum(ID), ID) and check Suppress When Value Is Null

andrew001 — Sun, 09 Dec 2012 13:40:39 GMT

thanks but I'd like to use set analisys, so the result will be indipendent by selection

I've tried but, at now, I haven't found the solution

simondachstr — Sun, 09 Dec 2012 14:31:53 GMT

Try creating a dynamic dimension like this:

=aggr(Only(ID), ID))

Then you should be able to use set analysis with the function Only displaying your desired values.

In your case I think the following would to the job:

=aggr(Only({$<ID={"*"}-{">0"}>} ID), ID)