topic Re: Convert if condition to Set in QlikView

Convert if condition to Set

Anonymous — Mon, 22 Feb 2016 12:36:50 GMT

Hi All,

I am having following if condition which needs to be converted into Set analysis

Count((if([DB DATE]>=$(Start_date) And (DB_DATE)<=$(End_date),[Instrument No])))

-Jay

Re: Convert if condition to Set

tresB — Mon, 22 Feb 2016 12:41:03 GMT

Count({<[DB DATE]={'>=$(Start_date) <=$(End_date)'}>} [Instrument No])

Re: Convert if condition to Set

tamilarasu — Mon, 22 Feb 2016 12:43:31 GMT

Hi,

Try,

Count({<[DB DATE]={">=$(Start_date)<=$(End_date)"}>}[Instrument No])

Re: Convert if condition to Set

sunny_talwar — Mon, 22 Feb 2016 13:01:06 GMT

In addition to the below comments, I would also make sure that $(Start_date) and $(End_date) has same format as DB DATE for this to work. You can check this by adding ='>=' & $(Start_date) & '<=' & $(End_date) to a text box object to check if you get the date range you want in the same format as DB Date.

Re: Convert if condition to Set

Colin-Albert — Mon, 22 Feb 2016 13:05:45 GMT

If you add the set expression column with a blank label, you can see the evaluated set expression in the column label without needing to create an extra text box.

Re: Convert if condition to Set

sunny_talwar — Mon, 22 Feb 2016 13:12:07 GMT

Agreed Colin‌, but I usually use the text box approach because next step for me is to just copy the the whole text box expression and put it between dollar sign expansion -> $(=TextBoxExpression).

In this case -> Count({<[DB DATE]={"$(='>=' & $(Start_date) & '<=' & $(End_date))"}>}[Instrument No])

You may not like my approach, but this gives the exact same result and make me feel like I am in control of what is going on

Best,

Sunny