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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
trdandamudi
Master II
Master II

8 different ways you can refer a variable in set analysis expression.

I was working on a set analysis expression and was able to refer the variable in 8 different ways.. This is very interesting and I just want to share this here with the community. Did anyone came across these 8 expressions or do you think there are more!!!!

You_Can_Write_8_Different_Ways_In_Set_Analysis_When_You_Have_A_Variable_In_The_Set.jpg

1)  =sum( {$<PolicyNo = {'$(vPolicy)'}>} Sales )

2)  =sum( {$<PolicyNo = {"$(#=vPolicy)"}>} Sales )

3)  =sum( {$<PolicyNo = {$(vPolicy)}>} Sales )

4)  =sum( {$<PolicyNo = {$(#vPolicy)}>} Sales )

5)  =sum( {$<PolicyNo = {$(=vPolicy)}>} Sales )

6)  =sum( {$<PolicyNo = {$(#=vPolicy)}>} Sales )

7)  =sum( {$<PolicyNo = {$(=(vPolicy))}>} Sales )

😎  =sum( {$<PolicyNo = {$(= =vPolicy)}>} Sales )

2 Replies
Anil_Babu_Samineni

Nice Job Thanks my dear brother. Try to change the DOCS instead of thread. So that, People will start the discussion.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ramasaisaksoft

Good Work Thirumala. Thanks for sharing KT