topic Re: Getting all values are null() in Pivot table in QlikView

Getting all values are null() in Pivot table

vidhya91gct — Tue, 03 Jul 2018 05:56:35 GMT

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:

Pivot Table:

Used columns:

Expected Output:

Need to show oly corresponding baselinegatevalue with month,

Please help me on this issue.

Thanks,

Vidhya k

Re: Getting all values are null() in Pivot table

ogautier62 — Tue, 03 Jul 2018 07:20:49 GMT

Hi,

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

it should work with baselineMonth in dimension,

what is your expression ?

regards

Re: Getting all values are null() in Pivot table

vidhya91gct — Tue, 03 Jul 2018 07:37:27 GMT

Hi,

Please find the below expression ,

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

Thanks,

Vidhya K

Re: Getting all values are null() in Pivot table

ogautier62 — Tue, 03 Jul 2018 08:19:36 GMT

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

only or maxstring for example

Re: Getting all values are null() in Pivot table

vidhya91gct — Tue, 03 Jul 2018 09:08:24 GMT

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,

Thanks,

Vidhya K

Re: Getting all values are null() in Pivot table

ogautier62 — Tue, 03 Jul 2018 09:23:05 GMT

you have two values for BaseLineGateVal : SOE and blank

try this maybe :

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

Re: Getting all values are null() in Pivot table

vidhya91gct — Tue, 03 Jul 2018 09:49:05 GMT

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')

Re: Getting all values are null() in Pivot table

ogautier62 — Tue, 03 Jul 2018 09:54:05 GMT

not(isnull(trim(BaselineGateVal)))

to remove blank

Re: Getting all values are null() in Pivot table

vidhya91gct — Tue, 03 Jul 2018 12:01:45 GMT

Hi,

I tried this expression,

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

but still getting null() values .

Re: Getting all values are null() in Pivot table

ogautier62 — Tue, 03 Jul 2018 13:29:37 GMT

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')