missing months as 0

[#1]

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

[datanibbler]

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

[agomes1971]

Hi,

yes that should be the best option.

Regards

André Gomes