topic Re: show and hide expression on bar chart based on selection in list box in QlikView

show and hide expression on bar chart based on selection in list box

alec1982 — Tue, 02 Dec 2014 20:42:39 GMT

hi all,

I have created a bar chart with 4 expressions and checked condition on top of each expression to show and hide based on a selection from list box..

The issue is when the user select two items from the list box then two expression should show up on the bar chart while it shows no expression when the user select more than one value..

Any idea what should be added on the condition expression?

Re: show and hide expression on bar chart based on selection in list box

Tue, 02 Dec 2014 21:46:16 GMT

Hi,

What is the conditional expression that you used ?

Try for example:

GetSelectedCount(FieldName) >= 1

The expression will then be displayed when 1 or more values are selected within your listbox.

Re: show and hide expression on bar chart based on selection in list box

alec1982 — Wed, 10 Dec 2014 15:00:55 GMT

hi,

Thank you for your reply..but that's not what is required.

Here is the Scenario:

I have a table with Country, Red Sales, Green Sales and Yellow Sales and I created a stacked bar chart with the sales by country based on colors..

I have created an inline table with one column Red, yellow and green.

I am trying to add an expression condition to hide/show the expressions of the sales colors based on the list box of the colors..

any help is appreciated

Re: show and hide expression on bar chart based on selection in list box

saurabh5 — Wed, 10 Dec 2014 15:16:41 GMT

Hi Alec,

Use the below script and then for chart use type as dimension and noof sales in expression.it may suffice your need.

LOAD KEY , 'Redsales' AS Type, Redsales AS NoOfsales , 1 AS Flag
Resident xyz where Redsales <> 0 and len(trim(Redsales)) <> 0
;

LOAD KEY , 'Greensales' AS Type, Greensales AS NoOfsales , 1 AS Flag
Resident xyz where Greensales <> 0 and len(trim(Greensales)) <> 0
;

LOAD KEY , 'Yellowsales' AS Type, Yellowsales AS NoOfsales , 1 AS Flag
Resident xyz where Yellowsales <> 0 and len(trim(Yellowsales)) <> 0
;

Re: show and hide expression on bar chart based on selection in list box

alec1982 — Wed, 10 Dec 2014 15:22:46 GMT

hi Saurabh,

Thank you for your help! I am looking for a solution within the front end. I can use cross table function to get similar solution to yours but I have no ability to change the data model for now..