topic Re: Distinct in variable in QlikView

Distinct in variable

Wed, 30 Sep 2015 08:08:09 GMT

I have $(Actkey) in my dimention.

$(Actkey) ='Activity_KEY_'&'$(vLanguage)

in my dimention consider this Activity_Key has many vales Sales, Training, Marketing etc untill 6 values.

But in my chart legend its getting repeated and show more than 6 values. if i try to use distinct, where should i add it?

Re: Distinct in variable

MK_QSL — Wed, 30 Sep 2015 08:19:35 GMT

Where are you using this Variable? What is vLanguage? You can use something like Only(Distinct Activity_KEY)

Re: Distinct in variable

jonathandienst — Wed, 30 Sep 2015 08:23:32 GMT

What you are doing, and what you want is not at all clear. I suggest that you upload a sample qvw and explain exactly (with examples) what you need to be added or changed in the QVW.

Re: Distinct in variable

avinashelite — Wed, 30 Sep 2015 09:55:56 GMT

can elaborate bit more on your requirement

Re: Distinct in variable

sunny_talwar — Wed, 30 Sep 2015 09:58:57 GMT

Can you share a screenshot of what you are seeing?

Re: Distinct in variable

SreeniJD — Wed, 30 Sep 2015 10:04:03 GMT

Hi Nilanjan,

If I understand you correctly, you have the activities like Sales, Training, Marketing and also different languages like English, Spanish, Chinese.. etc.,

if you will create a key obviously your activities will be multifolded based on the different languages that were suffixed to your $(Actkey) ='Activity_KEY_'&'$(vLanguage).

Don't apply distinct on the combination of Activities and Languages, but do it only on activities to get distinct values.

HTH

Sreeni

Re: Distinct in variable

nagarjuna_kotha — Wed, 30 Sep 2015 10:04:54 GMT

Can u share sample File /?