Qlik Sense Alternate States

[arvindjha2051]

Hello Team,

I have a Table , there i have two measures.

Both measures should be dynamic based on Quarter selection.

First : Sum({$<Quarter = {"$(=getfieldselections(Quarter))"}>}Sales)

Second : Sum({[Alternate State]}Sales)

But it does not work in Set Analysis say if i want sum(sales) where Status = WON.

How to show the same?

Regards,

Arvind

[juliensaintmaxent3113]

hi,

I don't understand exactly what you want.

you don't need to put quarter in your set analysis to be dynamic on your quarter field.

you want to show sales with status won, so sum({$<Status={'WON'}>}sales) and with alternate state sum({[AlternateState]<Status={''WON'}>}sales)

CAn you explain your problem with a screenshot please?

Bye