topic Re: Changing chart expression based on selection in QlikView

Changing chart expression based on selection

Mon, 12 May 2014 09:05:21 GMT

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!

Re: Changing chart expression based on selection

anbu1984 — Mon, 12 May 2014 09:11:48 GMT

Check Reports tab from the below link

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

Re: Changing chart expression based on selection

anbu1984 — Mon, 12 May 2014 09:13:21 GMT

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

Re: Changing chart expression based on selection

Mon, 12 May 2014 09:14:45 GMT

Or look into my example in this thread:

Alternate states and possibility to connect charts

Re: Changing chart expression based on selection

c_gilbert — Mon, 12 May 2014 09:20:19 GMT

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])

))

Re: Changing chart expression based on selection

jsingh71 — Mon, 12 May 2014 09:23:34 GMT

HI OG,

I Created one sample application . find it in attachment.

Hope this will help you.

--Jai