Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qliksense - Chart with 2 dimensions, One Date & One Character

Hi everyone,

I am trying to build a stacked chart with 2 dimensions, one of which is a date and the other is a character.

Please find the attachment with the excel equivalent of what I am trying to achieve.

One thing I tried is creating a new dimension combining the two (Type&Date) but then the problem is the axis won't be sorted properly as the new variable will be a character and will ignore the date within.

Please, could anyone advise if there is a better way to achieve this ?

Thanks very much

Arun

2 Replies
MVP
MVP

Re: Qliksense - Chart with 2 dimensions, One Date & One Character

What about doing it like this may be:

Dual(Type&Date, Date)

Re: Qliksense - Chart with 2 dimensions, One Date & One Character

Or maybe like this: Dual(Type & ' - ' & Date, FieldIndex('Type',Type)*100000 + Date)


talk is cheap, supply exceeds demand