help regarding dynamic change of expression in charts

[Anonymous]

hi all,

i have a table where i am having the sales amount , sales volume and gross margin profit . i need to get these three feilds into a list box so that when use select sales amount all the expressions in the bar charts has to change as sum(sales amount),, when the user select sales volume the expression should change as sum(sales volume),, and so on,, how can i get this done ,,, please help jagan‌sunindia‌dvqlikview‌msolomov‌

thanks in advance

qvhelpplease.

[Anonymous]

You could make the expressions conditional on a variable and then have 3 text objects with actions to set the variable to show / hide the expressions as per your needs.

[jagan]

Hi,

Check this link hope this helps you.

Adhoc reporting in Qlikview

Customizable Straight Table

Regards,

Jagan.

[Anonymous]

Further to the above you may find this post QlikView App: At The Qlik Of A Button by stevedark‌ useful.

[Anonymous]

could you send a qvw with some sample data ?

[tresesco]

PFA

[danieloberbilli · Accepted solution]

Please find attached

[Anonymous]

i have four bar charts in my dashboard when i click on the sales amount i need all expressions in charts to get changed to sum(sales amount)  like wise i need all.

thanks in advance

qvhelpplease

[Anonymous]

i tried it all the ways but i am not getting it , can someone help me please !!!!

[sunny_talwar]

what is wrong with danieloberbillig‌'s solution? If that is not what you want then you will have to share some more information about what you are looking to do.

Best,

Sunny