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

Beginer Question. How to fix one filter criteria?

Wed, 25 Feb 2015 05:40:38 GMT

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?

jyothish8807 — Wed, 25 Feb 2015 05:43:23 GMT

Hi,

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

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

Regards

Wed, 25 Feb 2015 06:04:48 GMT

Works lika a charm! Thank u!

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

jyothish8807 — Wed, 25 Feb 2015 06:08:32 GMT

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

Wed, 25 Feb 2015 06:23:43 GMT

It's really helps!