Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can anyone show light on this issue? as it is an urgent requirement.
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)
Hi Mayil,
Thanks for your valuable suggestion. But I am getting the error while writing expression.
Regards
Krishna