Changing chart expression based on selection

[#1]

Hi guys,

I have a chart which I'd like to show multiple expressions on, based on user selection. How can I create a selection box (list box?) with certain column headings in (for example Column 1, Column 2), and when the user clicks on one, it changes the data in the chart to reflect this? Do I need to use a variable in the chart expression, and a custom expression in the list box?

thanks!

[anbu1984]

Check Reports tab from the below link

Qlik Demos: See QlikView in Action | Demo.Qlik.Com

[anbu1984]

Check Reports tab in Expense management app. This app is available in qlikview demos

[#4]

Or look into my example in this thread:

Alternate states and possibility to connect charts

[c_gilbert]

There are probably several ways of doing it, but I would create a table using the inline load in the script, e.g.

ChoicesTable:

LOAD * INLINE [
Choices

Choice1

Choice2

Choice3

Choice4

];

Then the expression of the chart would go something like:

=if([Choices] = 'Choice1', sum([something]),

  if([Choices] = 'Choice2', sum([something2])

))

[jsingh71]

HI OG,

I Created one sample application . find it in attachment.

Hope this will help you.

--Jai