Assigning dynamic value for variable for calculated expression

[deepakqlikview_123]

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

[Gysbert_Wassenaar]

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

[deepakqlikview_123]

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

[marcus_malinow]

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

[Gysbert_Wassenaar]

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.

[deepakqlikview_123]

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

[Gysbert_Wassenaar · Accepted solution]

Try this expression:

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

[deepakqlikview_123]

thanks gysbert