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: 
narayanaqlik
Creator
Creator

How to get second dimension Labels for corresponding for first dimension in qliksense?

Hi All qlik Experts,

Have a nice day.

I have requirement like , i want to display  trends data month over month for last 12 months here , if i am in 2020 Jan right

so, in my line chart i need to display for second  dimension 2020 for Jan 2020 and rest all are 2019 year should be display as a second dimension for all one value i.e 2019. 

 

Please suggest me here how to do ...

 

Thanks in advance....

 

5 Replies
oskarwila
Partner - Contributor II
Partner - Contributor II

Hola Narayanaqlik,

Lo que pides, lo tienes que hacer en el código de la medida no de la dimensión y el periodo que tengas como dimension no tiene que tener año o tiene que ser una fecha que no esté relacionada con el resto de tablas ya que si no te lo distribuirá por ella.

 

Saludos

Vegar
MVP
MVP

I don't think the shipped trend graphs in Qlik Sense supports your need. 

If I where in your shoes, I would have created an YearMonth field and used that field instead.

Take a look at my image below

image.png

narayanaqlik
Creator
Creator
Author

I am Extremely sorry , I am unable under stand that language,

Thanks for you r reply. But,

Could you please give the reply in English so that i can understand 

 

narayanaqlik
Creator
Creator
Author

Thanks Vager,

Very thanks for good reply...!

I have tried , but My client is not Interested in Year Month

Vegar
MVP
MVP

If this is a important feature then you could check out some of the premium extension providsers such as VizLib or AnyChart to see if they have this feature in ther offerings. Alternatively you could offer your client to create an extension to meet their vizualization needs.

You could also suggest to use altenative vizualisations. Maybe color instead of text to distinguish between years like in the image below.

image.png