Solved: Re: Associate chart problem - Qlik Community

Report Inappropriate Content · ‎2016-05-31

Hi,

I actually have this chart

It represent the number of service request by Site.

I have 2 different chart, one pivot table and a combine bar chart.

My problem is that I have a calendar based on request date, and somes Site wasn't exist in 2014 for example so if I select 2014 my bar chart is not align with my pivot table and I dont know how to handle this.

I want to always display every Site on my pivot table like i did in my bar chart...

Ex 2014 --> PLA and SHA desappear

Thanks for your help

sunny_talwar · ‎2016-06-01

Try this as your background color expression:

=if(Only({1} [VIGS CATEGORY]) = '3- Hospitality',rgb(102,194,150),

if(Only({1} [VIGS CATEGORY])='1- General Building Maintenance',rgb(141,170,203),

if(Only({1} [VIGS CATEGORY])='4- Office Services',rgb(255,217,47),

if(Only({1} [VIGS CATEGORY])='7- Other', rgb(252,115,98),

if(Only({1} [VIGS CATEGORY]) = '6- Food Services', rgb(187,216,84),

if(Only({1} [VIGS CATEGORY]) = '2- Pharma', rgb(231,138,210),

if(Only({1} [VIGS CATEGORY])='5- Janitorial', rgb(229,182,148),

if(Only({1} [VIGS CATEGORY]) = '8- Quotation', rgb(179,179,179)))))))))

View solution in original post

sunny_talwar · ‎2016-05-31

Have you tried unchecking 'Suppress Zero Values' on the presentation tab for your pivot table?

Report Inappropriate Content · ‎2016-06-01

Hi, Thanks for you answer.

I try yes, I did it on the combine chart and it works, we can see that i have not value for 2 "sites".

But if I do the same in my pivot table, no way...

sunny_talwar · ‎2016-06-01

Would you be able to share a sample?

Report Inappropriate Content · ‎2016-06-01

Sure, you can find it attached with this post

sunny_talwar · ‎2016-06-01

Check this expression:

=If(Len(Trim([VIGS CATEGORY])) > 0, If(Count(ITEMID) = 0, 0.0001, Count(ITEMID)))

Anonymous · ‎2016-06-01

=Dual(Count(ITEMID), count(TOTAL <[VIGS CATEGORY],SITE> {<YEAR=>} ITEMID))

Report Inappropriate Content · ‎2016-06-01

Hello Manuel,

Thanks for your help but it not work. Because using set analysis on year or month not allowed me to use my calendar, so I cant check my KPI for only 2014 for example. I have always the same result..

Report Inappropriate Content · ‎2016-06-01

WHat is the configuration of your check boxes on this case because if i take your expression its not better for me...
And if I open you file, its not works too...

sunny_talwar · ‎2016-06-01

Check here: