topic Dynamic variable in QlikView

Dynamic variable

Chanty4u — Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Tue, 24 Jul 2018 11:37:47 GMT

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 — Tue, 24 Jul 2018 11:38:12 GMT

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