topic Re: How to get second dimension Labels for corresponding for first dimension in qliksense? in App Development

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

narayanaqlik — Mon, 27 Jan 2020 07:50:18 GMT

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....

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

oskarwila — Mon, 27 Jan 2020 09:13:25 GMT

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

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

Vegar — Mon, 27 Jan 2020 09:37:32 GMT

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

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

narayanaqlik — Mon, 27 Jan 2020 09:38:40 GMT

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

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

narayanaqlik — Mon, 27 Jan 2020 11:47:39 GMT

Thanks Vager,

Very thanks for good reply...!

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

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

Vegar — Mon, 27 Jan 2020 21:00:29 GMT

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.