Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danielrogra
Creator
Creator

Set analysis not working - Ignore selections

Hello all

First of all,thank you for your time. I really appreciate it.

I have an issue with set analysis and I'm not able to solve it. The problem is the following:

As you can see in this thread ( Working with dates - Last date ), I want to display just the last date data. With some help I was able to do it. The problem is that I want to ignore any filter I have and it seems that it's not working just with year and month. The formula I'm using is:

sum({1<[date_variable] = {'$(maxdate)'}>})

where maxdate is: max(date([date_variable]))

I don't see where is the problem as I'm using 1 to ignore all the selections...Is there anyone who can help me?

Thanks so much

1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

you have to specify the identifier also in your variable as below:

=sum( {1< [date_variable] = {"=max({1}date([date_variable]))"}>} )

View solution in original post

7 Replies
sumanta12
Creator II
Creator II

Hi,

First take a text object and check that '$(maxdate)' value is coming properly or not.

shraddha_g
Partner - Master III
Partner - Master III

Also ignore selection in variable

Max({1}date(date_variable))

It might help

martinpohl
Partner - Master
Partner - Master

Also,

somewhere you need to calculate your expression (your maxdate) so set

sum({1<[date_variable] = {'$(=maxdate)'}>} A)

or in maxdate: =max(date([date_variable]))

by the way:

a line based set sxpression (if you want to calculate max(date) in each line of your table chart), won't work. For that you need another solution, so check your needs.

Regards

satheshreddy
Creator III
Creator III

Hi Daniel,

Please Try below Exp

sum({1}{<[date_variable] = {$(maxdate)}>})

Regards

Sathish

agigliotti
Partner - Champion
Partner - Champion

you have to specify the identifier also in your variable as below:

=sum( {1< [date_variable] = {"=max({1}date([date_variable]))"}>} )

danielrogra
Creator
Creator
Author

Hello mate

Thanks for your help. I already did it and it's working properly

danielrogra
Creator
Creator
Author

Hello Andrea!!That was the problem!!I had to do the same in the max variable!!

Thank you very much for your help!