Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

Evaluate the set analysis in Load Inline

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

Labels (3)
3 Replies
krishna20
Specialist II
Specialist II
Author

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:

MayilVahanan_0-1607049744026.png

Dim: FY, Classification

exp: =$(=Expression)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
krishna20
Specialist II
Specialist II
Author

Hi Mayil,

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

krishna20_0-1607063882383.png

Regards

Krishna