topic How works Conditional in chart properties in QlikView

How works Conditional in chart properties

Anonymous — Thu, 24 May 2012 17:31:00 GMT

Hi guys,

How works Conditional in chart properties?

Could you show any example?

Thanks in advanced,

How works Conditional in chart properties

Jason_Michaelides — Thu, 24 May 2012 17:39:52 GMT

I'm sure it's explained in the reference manual isn't it!? 🙂

Essentially in v11 you can now enter a Boolean expression here. If it is true them the expression will be calculated and displayed in the chart. If it's false, it won't be. You might use this to allow users to decide which expressions they want to show in the chart.

Hope this helps,

Jason

How works Conditional in chart properties

Anonymous — Thu, 24 May 2012 18:00:23 GMT

Hi Jason,

I have an expression.

But I want to calculate it only for variable A with tag a.

I used in conditional : If(A='a',1)

But it didn't work.

Could you show how it should be?

Regards,

How works Conditional in chart properties

Jason_Michaelides — Thu, 24 May 2012 18:21:10 GMT

Try just putting in

A='a'

Jason

How works Conditional in chart properties

Anonymous — Thu, 24 May 2012 18:41:38 GMT

I put A='a', my expression isn't shown.

I have 4 expressions Count(B),

but different only for A (a,b, c,d).

When I put in conditional A='a', it shows only for A=b, A=c, A=d.

I don't understand how this condition works.

How works Conditional in chart properties

Anonymous — Thu, 24 May 2012 20:02:45 GMT

If I use a conditional expression in a chart, my expression should work only when I select it in list box?

Does somobody know how to use set analysis or If condtional for all expression?

For example:

My main expression:

Count(B)*count(C)-count(D)*count(F)

It should be calculated only for A=aaa.

The result shold be the same as I use:

Count({<A={'aaa'}>}B)*count({<A={'aaa'}>}C)-count({<A={'aaa'}>}D)*count({<A={'aaa'}>}F)

Thanks,

How works Conditional in chart properties

Jason_Michaelides — Thu, 24 May 2012 21:14:51 GMT

Can you post a sample of your app?

Re: How works Conditional in chart properties

Anonymous — Fri, 25 May 2012 13:42:10 GMT

Hi Jason,

Please find attached file.

Thanks,