topic Re: missing months as 0 in QlikView

missing months as 0

Wed, 07 Jan 2015 15:26:26 GMT

Hi,

I have a calculated dimension for the month which should populate the no of deals to expiry in bar chart.

for some months i dont have deals , for that it should display 0

thanks

Re: missing months as 0

datanibbler — Wed, 07 Jan 2015 15:30:43 GMT

Hi,

that is always a bit tricky when you use the date of the data_table itself as dimension - displaying non-existent data in QlikView is a bit challenging.

Would it be an alternative to just use a master_calendar that you can link to that data_table and use the month from that as dimension? That way, months would be displayed with or without data in the fact_table.

HTH

Best regards,

DataNibbler

Re: missing months as 0

agomes1971 — Wed, 07 Jan 2015 15:34:53 GMT

Hi,

yes that should be the best option.

Regards

André Gomes