Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

antonybi
Contributor

Re: pivot table issue

Yes yes...I agreed.

can we find any other extension to accomplish this or by editing Jscript??

Chanty4u
Esteemed Contributor III

Re: pivot table issue

i dont think so as of now no.

Highlighted
sarahplymale
Contributor

Re: pivot table issue

You could try to use an outer join in your load script and then use something life if(isnull(value), 0, value) so that the null values are 0's instead of nulls.  That will make all those areas show in white with a 0 instead of grey with a '-'. It will greatly expand the size of your data model, but if it isn't large to begin with maybe that is acceptable.