topic Re: expression in QlikView

expression

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

HI Folks ,

I had question as follows looking for solution .

I have data as follows

Rules

Pan

DOB

Address

given a led checks to it

Table 2:

Rules Value

Pan 2

DOB 3

Address 4

Pan+DOB 4

Address+Pan 5

DOB+Address 6

If User Selects PAN then should display pan Value

If user selects PAN and DOB then should PAN count , DOB count and PAN+DOB Value

How can we achieve this

I am attaching sample QV file , Please have a look and advise me a solution

Thanks in advance !

qlikview979 — Tue, 23 May 2017 05:51:17 GMT

Hi,

May be its not possible with out association, in your table not having any association .

Anil_Babu_Samineni — Tue, 23 May 2017 05:54:51 GMT

Is this you are expecting?

Anonymous — Tue, 23 May 2017 06:01:30 GMT

No Anil .

If User Selects PAN then should display only PAN = Value is 2

If user selects PAN and DOB then should PAN count , DOB count and PAN+DOB i.e Value= 2 +3+4 = 9

avinashelite — Tue, 23 May 2017 06:23:57 GMT

based on your data set could you please give the eg's for the only PAN, PAN count , DOB count and PAN+DOB ?

vinieme12 — Tue, 23 May 2017 08:04:24 GMT

try below

sum({<rules = {$(=concat(DISTINCT chr(39)&'*'&Rules,'*'&Chr(39)&',')&'*'&chr(39))}>}Count)

OR create a variable for example

vRulesList = =concat(DISTINCT chr(39)&'*'&Rules,'*'&Chr(39)&',')&'*'&chr(39)

and use variable in Expression as below

sum({<rules = {$(vRulesList)}>}Count)