Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

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

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

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