topic Re: Sum of Pivot table in QlikView

Sum of Pivot table

mahendragaur — Tue, 25 Apr 2017 11:42:05 GMT

Hello,

I have pivot table and I want to get the sum of a column which contains values (Zero or null) but there are some values as 0 (number and text both). I tried Isnull() function but it didn't worked and it is not considering text '0' in calculation.

So, how can I convert text to numbers and get the sum of values.

Re: Sum of Pivot table

Anil_Babu_Samineni — Tue, 25 Apr 2017 11:48:08 GMT

Can you provide data if possible due to Aggregation functions won't calculate the Strings. If you have Numeric string then it could work. Better practice may be Live data and result data as you required

Re: Sum of Pivot table

kamielrajaram — Tue, 25 Apr 2017 12:12:56 GMT

Hi,

In your script use if(fieldname = '0',0, if (fieldname = 'zero', 0, if (isnull(fieldname)=-1,0,fieldname))) as fieldname.

Hope this helps

Kamiel

Re: Sum of Pivot table

mahendragaur — Tue, 25 Apr 2017 12:16:09 GMT

I want in expression. I think it'll be good if I'll convert text to number and then do the sum.