Want to show all dates in Daily Table. - Qlik Community

infosense_devel · ‎2016-07-19

Hello All,

I have one QVW in which i am fetching data of budget now issue is when i am showing this date and amount in one table at that time some dates are not showing due to there is no budget Amount for that date. i want to show all dates in that table in any case. whether that date have data or not i want to display all dates. is there any way to handle this in script or expression??

Thanks in advance.

Report Inappropriate Content · ‎2016-07-19

May be create A calendar obj?

PrashantSangle · ‎2016-07-19

Hi,

see master calendar

Calendars‌

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

infosense_devel · ‎2016-07-19

Thanks for your reply. but I want to show data in straight table.

infosense_devel · ‎2016-07-19

we all ready have master calendar but when we are joining Budget Date with date of master Calendar, so it is also showing only those date which have Budget amount.

Frank_Hartmann · ‎2016-07-19

have a look at the attached sample

hope that helps

Report Inappropriate Content · ‎2016-07-19

how about create "month-date" table in load script, then link/join them tgt.

Mark_Little · ‎2016-07-19

HI,

Make sure on dimension you have suppress when null unticked and show all values ticked.

Also on presentation make sure you have suppress zero values unticked.

But like mentioned above, the missing date have to be in the data. So if they don't you will need to create the calendar table.

Mark