to find missing days and colour the sundays in pivot table.

[#1]

Hi All,

I have a problem in qlikview.

I need to show branch wise and day wise collection in pivot chart, in which branch and days are dimension.

when i am seeing with all branches the pivot chart showing all the days, but when have click on particular branch some days are missing in the pvot, i have check why its not showing i noticed that per that particular branch on that days collection is not happen but i want to display the missing days also in pivot table even if the data is not there, and i also want to colour the sunday day in pivot chart.

please help me as i need it very urgent.....

thanks in advnace......

[spsrk_84]

Hi,

In pivot table there is option called" Supress Missing Values" in PRESENTATION TAB ..Uncheck that option and either in the dimension or even in the expression write the background expression with some filter condition and apply RGB condition.

hope u got the point..if not attacht he sample file.

Regards,

Ajay

[#3]

Hi Ajay,

thanks for ur suggestion.

the above suggestion i already done, but still it is not showing.

help me please.....

[spsrk_84]

Hi,

can u attach the sample file ...

Regards,

Ajay

[#5]

Hi...

Sum of AMOUNT	DAY
	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	(blank)	Grand Total
Total	10	20	0	40	50	60	70	80	90	100	110	120	130	140	0	160	170	180	190	200	210	220	230	240	0	260	270	280	290	300	310		4530

i want the data to display is above formate.

the yellow colour indicate its a sunday in that particular month, i want to hylight it and also i want display missing days with o values.

i am attaching sample data for u...

Data:

LOAD

* INLINE

[

;

Main:

LOAD

*

,

Day

(DATE) as

DAY

resident

Data;

drop

table

Data;

[spsrk_84]

Hi,

I have attached the file .go through that.

I have created one Mastercalendar such your dimension will be coming from that table i.e day since it is a master calendar it will contain all the days and when evre the there is no data also it will show Zero.

In the previous case since your Dimension doesnot have that particular data value so the particular data value willnot appear in tha chart hence it will not be possible for you to see those zero values also.

Hope it is clear now...:)

cheers,

Ajay

[#7]

Hi,

Please uncheck "suppress null values" in dimension tab and "suppress zero values" in presentation tab

I hope this will work .

Thanks,

Vivek