topic Using variables in set analysis in QlikView

Using variables in set analysis

Mon, 04 Jul 2011 06:54:47 GMT

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

Using variables in set analysis

kaushiknsolanki — Mon, 04 Jul 2011 07:03:37 GMT

Hi,

Can you please upload the qvw file.

Regards,

Kaushik Solanki

Using variables in set analysis

christian77 — Mon, 04 Jul 2011 07:06:42 GMT

Try

$(vShowSystem)='SystemA','SystemB',...,'SystemN'

Using variables in set analysis

Miguel_Angel_Baeyens — Mon, 04 Jul 2011 07:29:05 GMT

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Using variables in set analysis

Tue, 05 Jul 2011 07:21:07 GMT

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