topic formating conditionally in QlikView

formating conditionally

Wed, 25 Nov 2020 16:16:04 GMT

hi, i have a text box and a list box.

and i ahve two different charts named chart 1 and chart 2

so when i click on text box , chart 1 should appear on front and chart 2 should hide

and when i click on list box and select any item it should show chart 2 and hide chart 1.

please help

Re: formating conditionally

adamdavi3s — Thu, 24 Nov 2016 13:34:21 GMT

You could do this with a variable and the show conditions on the layout tab and for the listbox item you can use the get selected count

Will do an example in a second

Note that I also had to add a field trigger on the dimension in the listbox which sets the show variable to 0 for the first chart.

Settings> document properties> triggers tab > field event triggers

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

Re: formating conditionally

Anonymous — Thu, 24 Nov 2016 13:44:41 GMT

Hi,

Please find attached.

It just uses get selected count for the field you need to check against

the textbox clears the field selection

Chart 1 & 2 will show or hide based on whether the field is selected or not..

Hope it helps...

Re: formating conditionally

adamdavi3s — Thu, 24 Nov 2016 13:46:43 GMT

^ that is better, I over-complicated mine for some reason

Re: formating conditionally

Thu, 24 Nov 2016 14:24:02 GMT

actually my two charts chart 1 and chart 2 are same only the difference is when i click the text box in one chart i have changed the expression and in another another expression as bot the charts are attached. i am not getting the correct data.