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
Contributor
Contributor

Set Analysis Number Issue

Hi,

Having an issue get it to work, I think its probably simple fix. It is just to get the sum of LAST_UNIQUE for the latest record of the variable Brand_Weeks=.

This set analysis work ---->     =sum({$<Brand_Weeks={47}>}LAST_UNIQUE)

But if I remove the number 47 and replace with a variable, Max(Brand_Weeks), that is numeric it doesn't work 

=sum({$<Brand_Weeks={Max(Brand_Weeks)}>}LAST_UNIQUE)

I set the variable Brand_Weeks to be a numeric in the load script using this  Num#(Brand_Weeks) as Brand_Weeks, I also tried Num(Brand_Weeks) as Brand_Weeks in the load script

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

SUM({$<Brand_Weeks={$(=Max(Brand_Weeks))}>} LAST_UNIQUE) should do it.

View solution in original post

2 Replies
Highlighted
Contributor III
Contributor III

SUM({$<Brand_Weeks={$(=Max(Brand_Weeks))}>} LAST_UNIQUE) should do it.

View solution in original post

Highlighted
Contributor
Contributor

perfect thank you