Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion III

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
Highlighted

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
Highlighted

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

Highlighted

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)))