topic Re: Pivot table Expression in QlikView

Pivot table Expression

Tue, 15 Jul 2014 11:31:40 GMT

Hi All,

I am facing issue with null values. if the value is null it is displaying as 0.

This is the expression

=Sum({<WAVE = {"WAVE1"}>} DEALER_RECOMMENDATION_VALUE_CURRENT_WAVE) *0.2*100)

Please help.

maxgro — Tue, 15 Jul 2014 11:43:31 GMT

maybe you can use the nullcount to check for null, example

if(NullCount(exp)>0, '???', sum(exp))

jonathandienst — Tue, 15 Jul 2014 11:54:56 GMT

If displaying 0 is not correct, what would you like to see if the underlying field is null?

Tue, 15 Jul 2014 12:00:20 GMT

Hi,

i need to display null as empty. (Wave3, Wave4, Wave5 columns are empty)

This is how i display in SSRS report. I am trying to replicate the same in QV report.

Also i need to display the average. please help.

Thanks

Anonymous — Tue, 15 Jul 2014 12:05:19 GMT

= if ( Sum({<WAVE = {"WAVE1"}>} DEALER_RECOMMENDATION_VALUE_CURRENT_WAVE) > 0 ,

Sum({<WAVE = {"WAVE1"}>} DEALER_RECOMMENDATION_VALUE_CURRENT_WAVE) *0.2*100) ,

null() )

Tue, 15 Jul 2014 12:13:53 GMT

Thank you Bill.