populate missing data

Anonymous — Tue, 20 Nov 2018 16:30:34 GMT

Hi,

How to generate missing data in month wise.I have day level data.I need to show count based on the filters.

cust_id	dept	sub dept	max_amount	Date	id
101	emp	xyz	400,000.00	6/1/2018	1001
102	emp	xyz	400,000.00	6/1/2018	1001
103	IT	xyz	400,000.00	6/1/2018	1001
105	HR	xyz	200,000.00	9/24/2018	1002

result: if I select june1 I need to show customer count as 3, if I select dept as empI need to show the customer count as 2.

above count 3 and 2 should repeat for next months also(like id I select dept as empcount is 2 and if I select dpet as IT should show count as 1 for fallowed month until receive the data from database.

how to achieve this requirement.please help me ASAP.

Thank,

Pat

Re: populate missing data

AshutoshBhumkar — Tue, 20 Nov 2018 16:44:30 GMT

Hi Pratyusha,
this link might help.
https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394

Re: populate missing data

Anonymous — Wed, 21 Nov 2018 03:52:50 GMT

can you help me for my requirement based on filters I need count.. script please.

topic Re: populate missing data in QlikView

populate missing data

Re: populate missing data

Re: populate missing data