Solved: How to create a bar chart with highlighting curren... - Qlik Community

vikasmahajan · ‎2019-05-28

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 ?

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

kaushiknsolanki · ‎2019-05-28

Hi,

Here is solution.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

kaushiknsolanki · ‎2019-05-28

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

vikasmahajan · ‎2019-05-28

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

kaushiknsolanki · ‎2019-05-28

Hi,

Here is solution.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

vikasmahajan · ‎2019-05-28

Thanks

Worked for me

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

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