topic Re: How to make modifiers of set expression dynamic ? in QlikView

How to make modifiers of set expression dynamic ?

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

Hi All ,

How to make modifiers of set expression dynamic ?

I have two fields called Entityand SubArea .

My expression should be something like ;

sum({1<Field_of_My_choice={'A'}>}sales) .

Script

LOAD Area,

Entity,

Sales,

SubArea

FROM

[Dynamic Modifier.xlsx]

(ooxml, embedded labels, table is eNTITY);

Fields:

LOAD * INLINE [

Field

Entity

SubArea

];

I have solved this using pick match , though . But wanted to know if there is other way !!!

shekhar_analyti — Thu, 11 Jan 2018 13:18:35 GMT

Field of my choice means user has ability to select modifiers

Clever_Anjos — Thu, 11 Jan 2018 13:26:24 GMT

Please try with

sum({<$(=Only(Field))={'A'}>}Sales)

shekhar_analyti — Thu, 11 Jan 2018 13:33:35 GMT

Though sum({<$(=Only(Field))={'A'}>}Sales) worked but curly bracket before 'A' is having some red highlighted

shekhar_analyti — Thu, 11 Jan 2018 13:36:59 GMT

Clever_Anjos — Thu, 11 Jan 2018 15:38:31 GMT

it´s not a problem.

The parser editor isn´t understanding what we are trying to do.

Keep calm, it will work

shekhar_analyti — Fri, 12 Jan 2018 07:16:22 GMT

Thank you Anjos