Evaluate the set analysis in Load Inline

[krishna20]

Hi Folks,

I am trying to evaluate the set analysis in Load Inline table which is similar to https://community.qlik.com/t5/New-to-QlikView/Problems-using-variables-in-a-LOAD-INLINE/td-p/733451

I am trying to achieve in two ways this concept.

Step1:

Load * Inline [

ID, Dimension, Expression

1, Target, Sum({<FY={2020},Classification={'A1'}>}Netprice)

];

Step 2:

Let vTest=REPLACE( '=Sum({<FY={2020},Classification={|A1|}>}Netprice)', '|', chr(39));

ID, Dimension, Expression

1, Target, $(vTest)

];

My front end expression 

pick(match(Dimension, $(=concat( chr(39) & Dimension & chr(39), ',',ID))), $(=concat( Expression, ',',ID )))

I am failing with the both methods and not getting any value under expression. Could anyone suggest me the right way to achieve this.

@Gysbert_Wassenaar , @MayilVahanan , @Anil_Babu_Samineni , @sunny_talwar 

Thanks

Krishna

[krishna20]

Can anyone show light on this issue? as it is an urgent requirement.

[MayilVahanan]

Hi @krishna20 

Try like below

Step1:

Load * Inline [
ID, Dimension, Expression
1, Target, "Sum({<FY={2020},Classification={'A1'}>}Netprice)"
];

SampleData:

Load * Inline
[
FY, Classification, Netprice
2020, A1, 1000
2021, A2, 2000
];

output:

Dim: FY, Classification

exp: =$(=Expression)

[krishna20]

Hi Mayil,

Thanks for your valuable suggestion. But  I am getting the error while writing expression.

Regards

Krishna