Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

qlik_aparnav
Contributor II

Show all value in pivot table

Hi community,

I have Day as column and month as row and

Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE)&'-'&Count(distinct{<FinalFlag ={'inactive'}>}ACCOUNT_CODE)

as expression.

Now i want to include days where FinalFlag is null(I want to show as blank) in pivot table.

Any suggestions on this?

Tags (1)
1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Show all value in pivot table

and u have null values for ur FinalFlag ? If so, why?

I'd suggest u to create a new value in ur script for this null() value; and then u can add it in all of ur expression .


maybe sthing like this:


Load *, if (len(trim(FinalFlag))=0,'null',FinalFlag) as newFlag;

load

....,

FinalFlag,

..

from ....;

5 Replies
OmarBenSalem
Esteemed Contributor

Re: Show all value in pivot table

How are u defining your FinalFlag field in the script?

sureshqv
Esteemed Contributor III

Re: Show all value in pivot table

if (isnull(fieldname)

Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE)&'-'&Count(distinct{<FinalFlag ={'new'}>}ACCOUNT_CODE))

qlik_aparnav
Contributor II

Re: Show all value in pivot table

FinalFlag has active,inactive and new status. I want to show new and inactive together in pivot table

qlik_aparnav
Contributor II

Re: Show all value in pivot table

It shows all days but values are blank

OmarBenSalem
Esteemed Contributor

Re: Show all value in pivot table

and u have null values for ur FinalFlag ? If so, why?

I'd suggest u to create a new value in ur script for this null() value; and then u can add it in all of ur expression .


maybe sthing like this:


Load *, if (len(trim(FinalFlag))=0,'null',FinalFlag) as newFlag;

load

....,

FinalFlag,

..

from ....;

Community Browser