topic Re: Help me on ..How to hide chart on selection in listbox in QlikView

Help me on ..How to hide chart on selection in listbox

Mon, 24 Nov 2014 09:42:29 GMT

i have the above combo box and i have to show sperately line chart and bar chart as according to the selection in the above listbox and hide this above combo box whenevr the selection is made in the above list box and get the following result as i am showing in the below images:

Re: Help me on ..How to hide chart on selection in listbox

alexandros17 — Mon, 24 Nov 2014 09:50:12 GMT

in cinditionl show of yhe expresion set the condition Getfieldselections(mesure)=myVal ...

Let me know

Re: Help me on ..How to hide chart on selection in listbox

tresB — Mon, 24 Nov 2014 09:52:20 GMT

Use two expressions, one for bar, another for line. Now use enabling condition for these expressions. Check the attached qvw.

Re: Help me on ..How to hide chart on selection in listbox

aveeeeeee7en — Mon, 24 Nov 2014 10:00:20 GMT

You can use GetFieldSelections() Function to Hide the Chart.

First, create a Variable in the Backend Script. Like this:

LET vVarHide='Combo';

Secondly, Create 2 copies of Orginal Chart:

1) Original Combo Chart (Go to Properties> Layout>Conditional Expression: GetSelectedCount(Measure)='0' )

2) Bar Chart (Go to Properties> Layout>Conditional Expression: GetFieldSelections(Measure)='1' )

3) Line Chart (Go to Properties> Layout>Conditional Expression: GetFieldSelections(Measure)='2' )

See, the Attachment & Snapshots.

Regards

Av7eN

Re: Help me on ..How to hide chart on selection in listbox

Mon, 24 Nov 2014 10:03:46 GMT

Dear,

pls send me the image file of above qvw .i am using personal edition so it is not opening here.

Thanks

Re: Help me on ..How to hide chart on selection in listbox

Mon, 24 Nov 2014 10:06:05 GMT

Dear,

pls send me the image file of above qvw .i am using personal edition so it is not opening here.

Thanks

Re: Re: Help me on ..How to hide chart on selection in listbox

aveeeeeee7en — Mon, 24 Nov 2014 10:18:26 GMT

Create a Variable:

LET vVarHide='Combo';

See the Attached Snapshots.

Regards

Av7eN

Re: Re: Help me on ..How to hide chart on selection in listbox

Mon, 24 Nov 2014 10:44:26 GMT

Dear,

Thank u so much for ur reply...but i need to keep select one value in measure listbox always either 1 or 2 as according to my another requirements.Hence the measure selectedcount will never have a value equals to zero.So in that case what i have to do to display the combo chart and then after to hide it as according to display another chart on the same palce..pls let me know...i need a help..

thanks,

Re: Help me on ..How to hide chart on selection in listbox

aveeeeeee7en — Mon, 24 Nov 2014 11:09:27 GMT

1) For Combo Chart don't use any Conditional Expression.

2) Create 2 Copies of Combo chart and place it little away from the Original Chart. See below:

Hope that helps you.

Regards

Av7eN