Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
AmCh
Creator
Creator

Variable in chart expression

Hi all,

I defined a variable test_c which depends on ValueLoop(1,o) (o is variable as well).

I tried to create a bar chart with dimension ValueLoop(1,o) and expression test_c, but it is showing a constant value along all dimension values, which is not correct.

When I write the expression/formula of test_c explicity in chart expression, it is shown correctly.

How can I use a this variable correctly in chart expression?

 

Thanks in advance.

 

1 Solution

Accepted Solutions
MarcoWedel
MVP
MVP

Try dollar sign expanding  your variable like this:

 

QlikCommunity_Thread_t5_QlikView-App-Dev_Variable-in-chart-expression_td-p_1839359_Pic2.pngQlikCommunity_Thread_t5_QlikView-App-Dev_Variable-in-chart-expression_td-p_1839359_Pic3.pngQlikCommunity_Thread_t5_QlikView-App-Dev_Variable-in-chart-expression_td-p_1839359_Pic4.png

 

hope this help

Marco

View solution in original post

3 Replies
MarcoWedel
MVP
MVP

Hi,

can you please post a small example to demonstrate the issue and test solutions with?

thanks

Marco

AmCh
Creator
Creator
Author

Hi,
test_c=ValueLoop(1,o)*3+m  (o and m are input variables)


Dimension:

AmCh_0-1632985542781.png

Expressions:

AmCh_1-1632985737734.png

 

Result in chart:

AmCh_2-1632985827857.png



Any help please?

Thanks in advance.

MarcoWedel
MVP
MVP

Try dollar sign expanding  your variable like this:

 

QlikCommunity_Thread_t5_QlikView-App-Dev_Variable-in-chart-expression_td-p_1839359_Pic2.pngQlikCommunity_Thread_t5_QlikView-App-Dev_Variable-in-chart-expression_td-p_1839359_Pic3.pngQlikCommunity_Thread_t5_QlikView-App-Dev_Variable-in-chart-expression_td-p_1839359_Pic4.png

 

hope this help

Marco