Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
neha_sri
Creator III
Creator III

Conditional Expression

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??

8 Replies
its_anandrjs

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

avinashelite

Hi Neha,

Please find the attachment for the solution.

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

Regards,

@vi

neha_sri
Creator III
Creator III
Author

I am not able to find any attachment

neha_sri
Creator III
Creator III
Author

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

Not applicable

Load * Inline

[

Metric,Value

meter,1

km,1000

km*100,1000*100

];


In chart divide/Multiply the expression by value


avinashelite

Hi Neha,

Please find the attachment for the solution.

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

Regards,

@vi

jsingh71
Partner - Specialist
Partner - Specialist

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.

its_anandrjs

Did you check my reply.