topic Re: Show al dates in Pivot table in QlikView

Show al dates in Pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have the below pivot table which shows data for last 7 days.

Dimension : CDate

LOB

Expression I have used is =sum({<CDate = {">=$(=today() - 6 ) <$(=today() +1)"}>} Sales)

Cdate/LOB	Manual	Auto	Referred
10/19/2017	10	0	0
10/18/2017	10	35	0
10/17/2017	78	39
10/16/2017	67	6	6
10/14/2017	0	78	0
10/13/2017	89	0	8

In the above table we don't have any entry for data 10/15/2017 so that date is skipped. Is there any way to show that date irrespective of whether data is there?

When I clicked "Show all values" its not restricting to 7 days and shows all the dates.

Any help would be much appreciated.

Thanks,

Anupama Jagan

Re: Show al dates in Pivot table

its_anandrjs — Thu, 19 Oct 2017 08:59:06 GMT

In your chart, if you select suppress when value null then removes and select show all values in all dimension and then check what result you get. Also, check first do you have any line items for this date in a row in your data model or if not exists you need a correct master calendar in the data model.

Re: Show al dates in Pivot table

Anonymous — Thu, 19 Oct 2017 09:24:44 GMT

No line item is there for that particular date in our DB. so should I create a master calendar which generates last 7 days?

Will you be able to help with it?

Thanks,

Anupama Jagan

Re: Show al dates in Pivot table

matteo_mi — Thu, 19 Oct 2017 09:40:13 GMT

You may can generate the missing date , look this thread

Filling in the missing data

Re: Show al dates in Pivot table

Anonymous — Thu, 19 Oct 2017 09:48:36 GMT

In that the values are getting populated, whereas in mine the missing dates should have only 0. Is that possible?

Re: Show al dates in Pivot table

florentina_doga — Thu, 19 Oct 2017 14:07:44 GMT

pls see attach