Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Beginer Question. How to fix one filter criteria?

Hi,

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

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

Regards

KC

Best Regards,
KC
4 Replies
jyothish8807
Honored Contributor II

Re: Beginer Question. How to fix one filter criteria?

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

Re: Beginer Question. How to fix one filter criteria?

Works lika a charm! Thank u!

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

jyothish8807
Honored Contributor II

Re: Beginer Question. How to fix one filter criteria?

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

Re: Beginer Question. How to fix one filter criteria?

It's really helps!

Community Browser