topic Re: Straight Table chart in QlikView

Straight Table chart

bharatkishore — Wed, 14 Feb 2018 09:27:43 GMT

Hi All,

I have a straight table chart and added few dimensions and expression.

Now I need to see data for all the months like below one where ever data is there it should come for all the months and where data is not there it should show 0.

But when i include the original formula for Cons field the chart is showing for only months where data is available like below:

Can you please help me how can i achive it. Attached app for more ref

Thanks,

Bharat

Re: Straight Table chart

YoussefBelloum — Wed, 14 Feb 2018 09:33:42 GMT

Hi,

you can modify the conso formula to this:

Sum({1}Consumption)

or you can uncheck this option on the presentation tab:

Re: Straight Table chart

bharatkishore — Wed, 14 Feb 2018 10:41:25 GMT

Thank you so much..

Re: Straight Table chart

YoussefBelloum — Wed, 14 Feb 2018 10:59:52 GMT

You're welcome !

Good luck