Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Hi,
May be its not possible with out association, in your table not having any association .
Is this you are expecting?
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
based on your data set could you please give the eg's for the only PAN, PAN count , DOB count and PAN+DOB ?
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)