topic Assigning dynamic value for variable for calculated expression in QlikView

Assigning dynamic value for variable for calculated expression

deepakqlikview_123 — Tue, 21 Apr 2015 07:25:15 GMT

Hi All,

Below is the issue,

1.We are using variable for showing value for expression dynamically on chart.

2 But it is showing blank value on chart once we can maximize the chart. or if we can apply selection

3.If we can assign one perticular vaue for variable it works fine but our requirement is to assign value for variable dynamically not statically.

Can you please suggest on this.

Thanks

Re: Assigning dynamic value for variable for calculated expression

Gysbert_Wassenaar — Tue, 21 Apr 2015 07:28:51 GMT

I'm afraid I don't understand your question at all. Can you post a qlikview document that demonstrates the problem?

Re: Assigning dynamic value for variable for calculated expression

deepakqlikview_123 — Tue, 21 Apr 2015 09:31:46 GMT

Hi Gysbert,

I have uploaded the sample file for the same.

In attached chart for expression 5 i am using variable but when i can make any selection on chart line disappears.

Thanks

Re: Assigning dynamic value for variable for calculated expression

marcus_malinow — Tue, 21 Apr 2015 09:47:16 GMT

Deepak,

I've just taken a look and there is no expression 5, only 1 to 4.

Exactly what are you selecting. What is disappearing? And what are you expecting to see? And, what is the variable that is not working?

Marcus

Re: Assigning dynamic value for variable for calculated expression

Gysbert_Wassenaar — Tue, 21 Apr 2015 09:49:11 GMT

Your data only contains an indicator value for indicator_name 'Average of % Change in Supply - Same month last year' for country 'United States' for monthyear Dec 2014. As soon as you select any monthyear values that do not include Dec 2014 the expression cannot return a value, because there's no data to calculate with.

Re: Assigning dynamic value for variable for calculated expression

deepakqlikview_123 — Tue, 21 Apr 2015 10:19:09 GMT

Hi Gysbert,

Thanks for response but can you please suggest if i want to show perticular dates value for all dates what to do even after making selection.

Thanks

Re: Assigning dynamic value for variable for calculated expression

Gysbert_Wassenaar — Tue, 21 Apr 2015 10:21:53 GMT

Try this expression:

Avg(TOTAL {1<INDICATOR_NAME={'Average of % Change in Supply - Same month last year'},COUNTRY={'United States'}>}INDICATOR_VALUE)

Re: Assigning dynamic value for variable for calculated expression

deepakqlikview_123 — Tue, 21 Apr 2015 17:35:36 GMT

thanks gysbert