topic Re: 8 different ways you can refer a variable in set analysis expression. in QlikView

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

trdandamudi — Wed, 25 Nov 2020 16:16:04 GMT

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

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 )

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

Anil_Babu_Samineni — Mon, 21 Nov 2016 15:39:47 GMT

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

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

ramasaisaksoft — Tue, 22 Nov 2016 06:35:03 GMT

Good Work Thirumala. Thanks for sharing KT