Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

Dynamic variable

Hi All,

i m using below expression  with static value it is working   .. but when i place variable it is nor working what might be the issue?

My variable is 

vNewMaxQtr     =  2018Q3

so i need to use  instead of 2018Q3   the variable should be placed

Thanks

Chanty

1 Solution

Accepted Solutions
sunny_talwar

This isn't working?

=if(max(Dimensionality())=1,

sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fc'}>}Amount),

if(max(Dimensionality())=2,

sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fcc'}>}Amount),

if((Dimensionality())=0,sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fc'}>}Amount))

+sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fcc'}>}Amount)))

View solution in original post

2 Replies
sunny_talwar

This isn't working?

=if(max(Dimensionality())=1,

sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fc'}>}Amount),

if(max(Dimensionality())=2,

sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fcc'}>}Amount),

if((Dimensionality())=0,sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fc'}>}Amount))

+sum({$<Quarter={"$(=vNewMaxQtr)"},Type={'Fcc'}>}Amount)))

sunny_talwar

or

=if(max(Dimensionality())=1,

sum({$<Quarter={"$(=$(vNewMaxQtr))"},Type={'Fc'}>}Amount),

if(max(Dimensionality())=2,

sum({$<Quarter={"$(=$(vNewMaxQtr))"},Type={'Fcc'}>}Amount),

if((Dimensionality())=0,sum({$<Quarter={"$(=$(vNewMaxQtr))"},Type={'Fc'}>}Amount))

+sum({$<Quarter={"$(=$(vNewMaxQtr))"},Type={'Fcc'}>}Amount)))