Distinct in variable

[#1]

Hi

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?

[MK_QSL]

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

[jonathandienst]

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.

[avinashelite]

can elaborate bit more on your requirement

[sunny_talwar]

Can you share a screenshot of what you are seeing?

[SreeniJD]

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

[nagarjuna_kotha]

Can u share sample File /?