Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Supertramp0
Contributor
Contributor

Pick and Set Analysis - Ignore Slicer

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

1 Solution

Accepted Solutions
eddie_wagt
Partner
Partner

Hello @Supertramp0 ,

Try something like this in your expression

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

 Regards

Eddie

View solution in original post

4 Replies
eddie_wagt
Partner
Partner

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

Supertramp0
Contributor
Contributor
Author

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

 

eddie_wagt
Partner
Partner

Hello @Supertramp0 ,

Try something like this in your expression

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

 Regards

Eddie

View solution in original post

Supertramp0
Contributor
Contributor
Author

Thanks Eddie. Worked well