topic Pick and Set Analysis - Ignore Slicer in QlikView

Pick and Set Analysis - Ignore Slicer

Supertramp0 — Thu, 01 Apr 2021 22:10:45 GMT

Hello,

In the attached sample app, I'd like to be able to ignore the year slicer in the displayed pivot table.

Any ideas?

Thanks

Shashank

Re: Pick and Set Analysis - Ignore Slicer

eddie_wagt — Fri, 02 Apr 2021 10:59:55 GMT

Hello @Supertramp0 ,

I see the tables are not connected with each other. I don't understand why... Because if you do so, then it should be no problem at all

[D8]: LOAD * INLINE [ D8ID, D8Name 1, Avg.TAT - Payout Ordered - Payout Resolved 2, % of Payouts - TAT < 5 BD 3, % of Payouts - TAT < 8 BD ] ; [D] : LOAD * INLINE [ Year, Score, D8ID 2015, 600, 1 2016, 700, 1 2017, 800, 1 ]

Then you can use in the expression:

sum({1}Score) or sum({$<Year=>}Score)

Regards Eddie

Re: Pick and Set Analysis - Ignore Slicer

Supertramp0 — Fri, 02 Apr 2021 14:12:51 GMT

Hello Eddie,

I can't connect them because Table D8 is simply being used as a table of values to describe certain calculations made in Table D ( the table with the actual data).

Is there a way to make it work without joining the tables - as there is no real join.

Thanks

Shashank

Re: Pick and Set Analysis - Ignore Slicer

eddie_wagt — Tue, 06 Apr 2021 08:22:44 GMT

Hello @Supertramp0 ,

Try something like this in your expression

PICK(minstring({1}D8ID),SUM({< Year = >}Score) )

Regards

Eddie

Re: Pick and Set Analysis - Ignore Slicer

Supertramp0 — Thu, 08 Apr 2021 14:45:08 GMT

Thanks Eddie. Worked well