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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Variables in Straight Table

Hi folks,
i have the enclosed straight table, each ratio(row) calculated by s varibale (i have around 100 ratio)

Ratio Expression

A VarA

B VarB

C VarC

VarA= sum( {<N={A}Month={'$(vMaxMonth)'}>} V)
VarB= sum( {<N={B}>} V)
VarC= sum( {<N={C}Month={'$(vMinMonth)'}>} V)

i put the following expression $(VarA) works great but i have 100+ ratios ( i try to avoid using IF)

any ideas ?????

0 Replies