topic Re: If then else expression in QlikView

If then else expression

Mon, 08 Dec 2014 05:27:55 GMT

I have a column, case type and two countries, Singapore and Malaysia.

I want to do a bar chart and have a count of case type for Singapore and Malaysia side by side.

The dimension is by months.

I'd like to use the if then else expression but I have no idea how to word it.

I want to do if country = singapore, then count (case type) if not, then do not count. How do I do that?

tresB — Mon, 08 Dec 2014 05:29:49 GMT

Try like:

Count({<Country={'Singapore'}>} [Case Type]) // Set analysis; performance wise better

Or,

Count(If(Country='Singapore', [Case Type]) ) // If ..then ..else

ashwanin — Mon, 08 Dec 2014 05:30:30 GMT

Below Expression provide you the count of CaseType where country=Singapore. Else it will not calculate.

=count({<Country={'Singapore'}>} CaseType)

PrashantSangle — Mon, 08 Dec 2014 05:32:02 GMT

Hi,

use set analysis Write two expression

count({<country={"Singapore"}>}case type)

and

count({<country={"Malaysia"}>}case type)

or if you want if else

then try like

count(if(country='Singapore',case type,if(country='Malaysia',case type)))

REgards

Anonymous — Mon, 09 Mar 2015 02:12:20 GMT

Hey Tresesco

how may I do the following expression in my chart?

- what I'm trying to do is - return only the results which are greater than or less than 3000 for example. for that i used

if(Sum({<Year=,Month]=, Date={'>=$(vYTDStart)<=$(vYTDEnd)'}>}Amount) >=3000 ,

Sum({<Year=,Month=, Date={'>=$(vYTDStart)<=$(vYTDEnd)'}>}Amount),'0') // this is returning one end of the result. but then if i go

if(Sum({<Year=,Month]=, Date={'>=$(vYTDStart)<=$(vYTDEnd)'}>}Amount) >=3000 ,

Sum({<Year=,Month=, Date={'>=$(vYTDStart)<=$(vYTDEnd)'}>}Amount),'0')

if(Sum({<Year=,Month]=, Date={'>=$(vYTDStart)<=$(vYTDEnd)'}>}Amount) <= - 3000 ,

Sum({<Year=,Month=, Date={'>=$(vYTDStart)<=$(vYTDEnd)'}>}Amount),'0') //this returns 0 or -1

if you could please point out what I'm doing that's incorrect.

Thanks.

Bon.