topic Re: dynamically show the text values for the chart in QlikView

dynamically show the text values for the chart

Fri, 04 Jul 2014 13:44:04 GMT

Hi Experts,

I have two expressions which is in a cyclic group Sum(Sales) and another one is Count(Transactions) against Customer dimention,

My query is as I need to show dynamically when i press the cyclic group as text to show '"The total Sales : 12 01 156 and for the same in "The Total transactions : 1209". And I tried to show using the Text is chart option but I don't know how to manage this.

Is this possible ... Please

Re: dynamically show the text values for the chart

alexandros17 — Fri, 04 Jul 2014 13:50:16 GMT

Please describe better the problem and if possible attach your application

Re: dynamically show the text values for the chart

Gysbert_Wassenaar — Fri, 04 Jul 2014 13:53:32 GMT

There's no function to get the active expression from a expression group. Perhaps you can use conditional display expressions to show/hide the expressions based on the value of a variable that you change using a button or textbox. You can then use that same variable to change the text you need to show. See here for some more information: Re: conditionally view an expression in a chart

Re: dynamically show the text values for the chart

juleshartley — Fri, 04 Jul 2014 13:56:50 GMT

Mybe have an invisible expression that is set to have 'Values on data points' only or similar, which is set to dislay the correct text/values and then have a conditional expression using getcurrentfield() to determine what cyclic group you are in?...