Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Associate chart problem

Hi,

I actually have this chart

Histo.PNG

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

Histo2.PNG

Thanks for your help

1 Solution

Accepted Solutions
sunny_talwar

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


Capture.PNG

View solution in original post

15 Replies
sunny_talwar

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

Not applicable
Author

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

Would you be able to share a sample?

Not applicable
Author

Sure, you can find it attached with this post

sunny_talwar

Check this expression:

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


Capture.PNG

manucamon
Specialist III
Specialist III

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

Not applicable
Author

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

Not applicable
Author

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

Check here:

Capture.PNG

Capture.PNG

Capture.PNG