Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
vikasmahajan
Esteemed Contributor

How to create a bar chart with highlighting current quarter and all the back dated qtr with color

Hi Team ,

Please find attached bar chart I wanted to create a bar chart with highlight Blue as current year color like Q1  & all quarters of Q1 for last years should be highlighted faint blue & rest gray. 

 

Please see attached image 

how to create a chart like this ?

 

 

1 Solution

Accepted Solutions

Re: How to create a bar chart with highlighting current quarter and all the back dated qtr with colo

Hi,

Here is solution.

Regards,

Kaushik Solanki

View solution in original post

4 Replies

Re: How to create a bar chart with highlighting current quarter and all the back dated qtr with colo

Hi,

Use Color by expression  and try If statement to color code your dimension.

For Example.

If(Quatername = Current Qtrname, Blue(),

If(Quaternumber = current Quarternumber,LightBlue(),Gray()))

 

Regards,

Kaushik Solanki

 

vikasmahajan
Esteemed Contributor

Re: How to create a bar chart with highlighting current quarter and all the back dated qtr with colo

Thanks Kaushik for your reply  can please explain how to create a quarter no I have attached sample application as well.

 

 

Vikas

Re: How to create a bar chart with highlighting current quarter and all the back dated qtr with colo

Hi,

Here is solution.

Regards,

Kaushik Solanki

View solution in original post

vikasmahajan
Esteemed Contributor

Re: How to create a bar chart with highlighting current quarter and all the back dated qtr with colo

Thanks

 

Worked for me

 

Vikas