Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Where are you using this Variable? What is vLanguage? You can use something like Only(Distinct Activity_KEY)
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.
can elaborate bit more on your requirement
Can you share a screenshot of what you are seeing?
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
Can u share sample File /?