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: 
vidhya91gct
Partner - Contributor
Partner - Contributor

Getting all values are null() in Pivot table

Hi All,

I am facing issue on pivot table, I am using master calendar and master calendar joined by using using autonumberhash(Proj_ID,Yearmonth and Date)with my table...while adding date field in master calendar ,it getting all values are null in pivot table as below.

MasterCalendar:

MS.PNG

Pivot Table:

PV.PNG

Used columns:

US.PNG

Expected Output:

Need to show oly corresponding baselinegatevalue with month,

OT.PNG

Please help me on this issue.

Thanks,

Vidhya k

9 Replies
ogautier62
Specialist II
Specialist II

Hi,

I didn't understand your data model and your graph :

it should work with baselineMonth in dimension,

what is your expression ?

regards

vidhya91gct
Partner - Contributor
Partner - Contributor
Author

Hi,

Please find the below expression ,

=if(BaselineMonth=YearMonth and Baseline=TDate,BaselineGateVal,'NA')

Thanks,

Vidhya K

ogautier62
Specialist II
Specialist II

you must put an agregation function in your expression, that's why it's null

only or maxstring for example

vidhya91gct
Partner - Contributor
Partner - Contributor
Author

Hi ,

For example,

I have selected 2016 in year and i m getting Baseline month is 07-2016 and BaselineGateVal is null() and SOE.

I want to show SOE for the corresponding month as below,

MM.PNG

OT.PNG

Thanks,

Vidhya K

ogautier62
Specialist II
Specialist II

you have two values for BaseLineGateVal : SOE and blank

try this maybe :

if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(BaselineGateVal)),BaselineGateVal,'NA')

vidhya91gct
Partner - Contributor
Partner - Contributor
Author

Hi,

Thanks for your suggestion,

Already i tried this expression,but it is not working and getting 'NA'only.

if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(BaselineGateVal)),BaselineGateVal,'NA')



ogautier62
Specialist II
Specialist II

not(isnull(trim(BaselineGateVal)))


to remove blank

vidhya91gct
Partner - Contributor
Partner - Contributor
Author

Hi,

I tried this expression,

if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(trim(BaselineGateVal))),BaselineGateVal,'NA')


but still getting null() values .

ogautier62
Specialist II
Specialist II

ok, ther's a last chance,

you still have two values, so must have an agregation function,

maybe :

if(BaselineMonth=YearMonth and Baseline=TDate and not(isnull(trim(BaselineGateVal))),maxString(BaselineGateVal),'NA')