topic Re: Using Variable in Set Analysis in QlikView

Using Variable in Set Analysis

mphekin12 — Thu, 18 Feb 2016 17:09:43 GMT

Hello,

I am trying to get a count of cases based a two variables that the end users set. I have tried several variations of the following formula:

count({$<($(vEndField)-$(vStartField))={'>0'}>}distinct CASE_NUMBER)

I cant seem to get this work. Any ideas?

Thank you!

Anonymous — Thu, 18 Feb 2016 17:11:23 GMT

HI,

Try this:

count({$<($(=($(vEndField)-$(vStartField))))={'>0'}>}distinct CASE_NUMBER)

sunny_talwar — Thu, 18 Feb 2016 17:11:55 GMT

May be try this:

Count(DISTINCT {<CASE_NUMBER = {"=$(vEndField) - $(vStartField) > 0"}>} CASE_NUMBER)

kaushiknsolanki — Thu, 18 Feb 2016 17:15:08 GMT

Hi,

Can you explain using some example.

Regards,

Kaushik Solanki

mphekin12 — Thu, 18 Feb 2016 17:51:04 GMT

Sorry sbobbyraj but your solution didn't work. Thanks for the help!

mphekin12 — Thu, 18 Feb 2016 17:51:30 GMT

Thanks Sunny, your solution seems to be working for me!