Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

elie_issa
Contributor II

How to show all months even if no data

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.

Tags (2)
12 Replies
zhadrakas
Valued Contributor

Re: How to show all months even if no data

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
Honored Contributor II

Re: How to show all months even if no data

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
Contributor II

Re: How to show all months even if no data

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
Valued Contributor

Re: How to show all months even if no data

sorry. i meant as Dimension.

Re: How to show all months even if no data

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
Contributor II

Re: How to show all months even if no data

not working thanks anyway

elie_issa
Contributor II

Re: How to show all months even if no data

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

gladi-cz
Contributor

Re: How to show all months even if no data

Hi Elie,

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

Petr

andrespa
Valued Contributor

Re: How to show all months even if no data

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


Community Browser