Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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?

1 Solution

Accepted Solutions
OmarBenSalem

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 ....;

View solution in original post

5 Replies
OmarBenSalem

How are u defining your FinalFlag field in the script?

Chanty4u
MVP
MVP

if (isnull(fieldname)

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

It shows all days but values are blank

OmarBenSalem

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 ....;