Variable with Set Modifier

Upali_Wijearatne — Thu, 01 Apr 2021 16:45:38 GMT

Hi Friend

I have created a variable as shown in Scn 1 and I want add set modifier to it only at the expression of my pivot table. I have tried it as shown marked in red color. But It does not work, But if I use as shown in scn 2 It works. Kindly help me add set modifier to varible

Re: Variable with Set Modifier

eddie_wagt — Tue, 06 Apr 2021 09:00:00 GMT

Hello @Upali_Wijearatne ,

Is it possible to share data or QVW? Otherwise it will be hard to see what you exactly are trying to achieve. It looks like you want to add a set modifier within an expression that you have declared as a variable. If you want to add an set modifier you will have to make a 'placeholder' within the expression you have written under vActual.

vActual = sum({$<DECRIPTION={'Sales'}$(vBusinessRule1)>}ACTUAL)

In this way you can define vBusinessRule1 (with a condition)....?

But again it is hard to help you without the example..

Regards Eddie

topic Re: Variable with Set Modifier in QlikView

Variable with Set Modifier

Re: Variable with Set Modifier