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: 
Not applicable

Beginer Question. How to fix one filter criteria?

Hi!

I have a table and a few filters, such as : date , ship name, company name and others.

In table I bring the product name and the total quantity produced by all ships, companies and so on (Sum ([Amount])).

Needs to be done so that the summation of data were taken only from the latest date selected. If nothing is selected - that for the maximum date.

I tried this function : Sum ({<Date = {"= Max([Date])" } >} [Amount]). The result was the same as in the function Sum ([Amount]).

Where am I wrong?

1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

Hi,

If you want only the max date to display then use this expression.

=Sum ({<Date = {'$(= Max([Date]))' } >} [Amount])

Regards

KC

Best Regards,
KC

View solution in original post

4 Replies
jyothish8807
Master II
Master II

Hi,

If you want only the max date to display then use this expression.

=Sum ({<Date = {'$(= Max([Date]))' } >} [Amount])

Regards

KC

Best Regards,
KC
Not applicable
Author

Works lika a charm! Thank u!

Can you explain a little bit, why I should use "$" in this case?

jyothish8807
Master II
Master II

you are welcome

So when ever you use any function or variable in set analysis you need to add a $ sign before that to evaluate it.

Over here I am using max function, so to evaluate the max function I used the $ sign.

Hope it helps.

Regards

KC

Best Regards,
KC
Not applicable
Author

It's really helps!