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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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 )

Labels (1)
2 Replies
Anil_Babu_Samineni
MVP
MVP

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
Master
Master

Good Work Thirumala. Thanks for sharing KT