topic Re: Conditional Expression in QlikView

Conditional Expression

neha_sri — Tue, 08 Jul 2014 05:07:09 GMT

Hi,

I have a bar chart,I want to show it in with respect to three expression(i.e meter wise,km,km*100 wise),I want that if I select meter I should be able to see bar chart with respect to meter,If I select km I should be able to see the chart km wise,and if I select both meter and km i should be able to see two bars in my chart .How can i do so??

Re: Conditional Expression

its_anandrjs — Tue, 08 Jul 2014 05:12:28 GMT

Try to add the inline table in model like

Load * Inline

[

LengthMetric,UnitValue

meter,

km,

km*100,

];

And on the chart use the conditional expression with selected values in the field LengthMetric

and in expression divide or multiply the LengthMetric value to find the exact result.

Hope this helps

Re: Conditional Expression

avinashelite — Tue, 08 Jul 2014 05:20:32 GMT

Hi Neha,

Please find the attachment for the solution.

Sorry initially i had posted a wrong file.Find the correct attachment.

Regards,

@vi

Re: Conditional Expression

neha_sri — Tue, 08 Jul 2014 05:43:32 GMT

I am not able to find any attachment

Re: Conditional Expression

neha_sri — Tue, 08 Jul 2014 05:44:24 GMT

I am not able to write this in front end.Can you please provide the conditional expression

Re: Conditional Expression

Tue, 08 Jul 2014 05:45:40 GMT

Load * Inline

[

Metric,Value

meter,1

km,1000

km*100,1000*100

];

In chart divide/Multiply the expression by value

Re: Re: Conditional Expression

avinashelite — Tue, 08 Jul 2014 05:46:13 GMT

Hi Neha,

Please find the attachment for the solution.

if ur not able to get the attachment please let me know.

Regards,

@vi

Re: Conditional Expression

jsingh71 — Tue, 08 Jul 2014 05:51:04 GMT

Are you using Personal Edition?

If yes then you are not able to open these solution which people provides you.

Because there are so many attachments available and you are telling, you are not able to see any attachment.

If these solutions are not the one which you are looking then plz upload any sample app then definately you will get the correct solution.

Re: Re: Conditional Expression

its_anandrjs — Tue, 08 Jul 2014 06:59:46 GMT

Did you check my reply.