How to show all months even if no data

[elie_issa]

Hi ALL,

Please check the attachment where we need to show all years ,quarters and months from 1-1-2017 till 31-12-2018 even if there is no filled data.

So when there is no data we need to show the cell in the table with no data.

Thanks for your support.

[zhadrakas]

Hello elie,

you can try this expression

if(len(trim(Month))=0. Month)

That will give you all NULL Values and blanks.

Use same logic for other fields

[devarasu07]

Hi,

try to ignore month selection from your chart object.

let's say you have measure as Sales then month is dimension then try like this

alt(sum( {$<Month=>} Sales) ,0)

Thanks,Deva

[elie_issa]

this is my expression that i am using in the pivot : SUM([Number of Openings])

To clarify what you mean , i have to make the change in the expression or dimensions ?

[zhadrakas]

sorry. i meant as Dimension.

[kaushiknsolanki]

Check this link.

Generating Missing Data In QlikView

It is for Qlikview but can also be applied to Qlik Sense.

Regards,

Kaushik Solanki

[elie_issa]

not working thanks anyway

[elie_issa]

thanks for your help but i am trying to do it from the expression or dimension outside the script if possible.

[gladi-cz]

Hi Elie,

have look to .qvf file. I solved in script.

Petr

[andrespa]

It's better to handle this kind of stuff in the load script. If you do that what Tim said but in the load script instead of in the dimension it should work:

LOAD

...

if(len(trim(Month))=0. Month)               AS     Month

...

FROM [Whatever];

Hope it helps,

Andrés