Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Fix one dimension in set analysis, let other dynamic

Hello experts, I need to fix one dimension in set analysis but still let others dynamic, E.g. sum({<date={"$(=max(date))"}>}sales)

For the other hand, I need to filter by country or department, but always get the last available date. I need something like  sum({<date={"1(=max(date))"}>}sales) 

 

Thanks!

Labels (3)
1 Solution

Accepted Solutions
Highlighted

Re: Fix one dimension in set analysis, let other dynamic

May be this

Sum({<date = {"$(=Max({1} date))"}>} sales)

View solution in original post

3 Replies
Highlighted
Specialist
Specialist

Re: Fix one dimension in set analysis, let other dynamic

Try the P() function

Sum({<date=P({1<date={"$(=Max(date))"}>}date)>}sales)

Highlighted
Creator
Creator

Re: Fix one dimension in set analysis, let other dynamic

Thanks @jwjackso but Date it's still dynamic. I want to permanently fix Date as max(Date) and ignore any future Date selections as well

Highlighted

Re: Fix one dimension in set analysis, let other dynamic

May be this

Sum({<date = {"$(=Max({1} date))"}>} sales)

View solution in original post