Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Distinct in variable

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?

6 Replies
MK_QSL
MVP
MVP

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

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
avinashelite

can elaborate bit more on your requirement

sunny_talwar

Can you share a screenshot of what you are seeing?

SreeniJD
Specialist
Specialist

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
Partner - Specialist II
Partner - Specialist II

Can u share sample File /?