Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used the following expression to show the sum of components for a given system.
count(DISTINCT{1<System= {'$(vShowSystem)'}>}Component)
Here I have taken the system into a variable usin ga macro.This wrked fine until I had a single value in a variable
But for multiple values in the variable the Expression is not working
Could anybody suggest a Workaround.
Regards
Navin Gorapalli
Hi,
Can you please upload the qvw file.
Regards,
Kaushik Solanki
Try
$(vShowSystem)='SystemA','SystemB',...,'SystemN'Hello,
This should work. You need to populate your variable taking into account the values you want to use later in set analysis. If they are strings, you need to enclose in single quotes and separate them with commas (as shown above by Christian), if they are numeric, they only need to be comma separated, no quoting needed.
Hope that helps.
BI Consultant
Guys,
Thank you for all your help.Was able to figure out the problem.
While taking the values into a variable from a macro I have attached ' at the beginning
and end of the string.
Regards
Navin Gorapalli