topic Re: How to compare a user selection and a value? in QlikView

How to compare a user selection and a value?

renzedegraaf — Tue, 31 Jan 2017 11:06:45 GMT

Hi,

The user wants to compare revenue growth for two years.

Suppose a user selects 2 values of field YEAR. I need the sum of VALUES for min(YEAR) in a column and the sum of VALUES for max(YEAR) in a second column so I can compute the growth between the 2 selected years.

I was trying (using set analysis) this:

sum({<YEAR = {"$(=min(YEAR))"} VALUE)

and

sum({<YEAR = {"$(=max(YEAR))"} VALUE)

But this does not work. Any suggestions?

Thanks in advance!

Re: How to compare a user selection and a value?

sunny_talwar — Tue, 31 Jan 2017 12:16:06 GMT

I don't see a reason for this not working.... Can you share a sample or snapshot to show what exactly do you get and explain as to what you are looking to get?

Re: How to compare a user selection and a value?

renzedegraaf — Tue, 31 Jan 2017 13:04:59 GMT

Hi Sunny,

I don't know how to upload my sample qvw, so here some screenshots.

Re: How to compare a user selection and a value?

sunny_talwar — Tue, 31 Jan 2017 13:31:56 GMT

Look here to see how a sample can be uploaded

Uploading a Sample

Re: How to compare a user selection and a value?

sunny_talwar — Tue, 31 Jan 2017 13:33:03 GMT

I think you are using two variation of Year (Year and YEAR).... QlikView is case sensitive and you need to make sure you are using the correct casing...

Sum({<Year = {"$(=min(Year))"} VALUE)

Sum({<YEAR = {"$(=min(YEAR))"} VALUE)

Re: How to compare a user selection and a value?

renzedegraaf — Tue, 31 Jan 2017 14:28:54 GMT

I uploaded a sample app to explain my problem.

Re: How to compare a user selection and a value?

sunny_talwar — Tue, 31 Jan 2017 14:51:13 GMT

You missed the closing set analysis syntax (>})

These are working now:

=Sum({<Year = {"$(=Min(Year))"}>} Revenue)

=Sum({<Year = {"$(=Max(Year))"}>} Revenue)

Re: How to compare a user selection and a value?

renzedegraaf — Wed, 01 Feb 2017 08:15:59 GMT

Thanks!