topic Re: Conditional expressions in QlikView

Conditional expressions

Wed, 04 Nov 2015 00:33:09 GMT

I have a field named Controlxx. The value can be 'Partially Effective' , 'Ineffective', 'effective'. I am trying to count up the records for a bar chart where the value can be 'Partially Effective' , or 'Ineffective' .

My dimension is a field named 'Control'. I am unable to get this to work. Can someone shed some light for me.

What is the proper syntax?

Thanks

Re: Conditional expressions

Kushal_Chawda — Wed, 04 Nov 2015 09:33:55 GMT

try

count ({<Controlxx={'Partially Effective' , 'Ineffective'}>} Amount)

Re: Conditional expressions

punitpopli — Wed, 04 Nov 2015 09:51:18 GMT

Hi erodman52‌,

Please find the attached sample file and let me know if this works for you.

Thanks,

Punit !

Re: Conditional expressions

Anonymous — Wed, 04 Nov 2015 10:01:55 GMT

I wud say, in a meaningful way:

Take Controlxx as dimension and Count(Control) or count(distinct(Control)) as expression.

Re: Conditional expressions

Mark_Little — Wed, 04 Nov 2015 10:04:25 GMT

Hi,

What exactly are you trying to show on the Bar Chart?

Is it two bars one showing the 'Partially Effective' , 'Ineffective' and another showing 'Effective'?

If so you could use two expressions

count ({<Control={'Partially Effective' , 'Ineffective'}>} Control)

And

count ({<Control={'Effective'}>} Control)

or you could make another field in the script that groups the two for your charts

IF(Control={'Partially Effective' , 'Ineffective', 0, 1) AS Effective.

The 0 and 1 are just flag and could be anything you need.

Mark

Re: Conditional expressions

Anonymous — Wed, 04 Nov 2015 10:04:40 GMT

What this Control dimension contain?

You can take Control as Dim & Expression is:

=count({<Controlxx={'Partially Effective' , 'Ineffective', 'effective'}>} Controlxx) //you can use distinct as well

Hope this will help!!

Re: Conditional expressions

Thu, 05 Nov 2015 00:48:44 GMT

Thank you for solving my issue. I used the same construct on another bar chart, containing two dimensions.

In this case the value could be 'E', or 'M'. I get the correct values, but the first line of the chart does not contain a value, it is blank, but it contains 1175 as the count. It is skewing the other values, as I don't see the individual lines of the graph because the numbers ae small.

Re: Conditional expressions

Anonymous — Thu, 05 Nov 2015 09:43:11 GMT

You can use Suppress Null Values Option in Dimension Tab