expression

[Anonymous]

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]

Hi,

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

[Anil_Babu_Samineni]

Is this you are expecting?

[Anonymous]

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]

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

[vinieme12]

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)