topic Re: No value on total in QlikView

No value on total

Mon, 13 Jul 2015 09:47:06 GMT

Hi everybody;

i have a issue, i have some value which are from a applymap, this is numeric number and i get it in "monetary" on the type of number.

But when i do a total that don't worK as you can see on attached file

do you know why?

Thanks a lot!

Re: No value on total

MK_QSL — Mon, 13 Jul 2015 09:48:27 GMT

Its very difficult to answer by only looking your JPG file. Kindly upload sample application or sample data!

Re: No value on total

Mon, 13 Jul 2015 09:51:55 GMT

Hi ,

Post sample data for more help...

Try like below,

Go to Expression properties>Total mode>select Total

properties>Number>select calculated field>select Number format setting >Number

Re: No value on total

amit_saini — Mon, 13 Jul 2015 09:52:13 GMT

Sab,

Not sure if you are doing like below to get the sum total:

Thanks,

Re: No value on total

Mon, 13 Jul 2015 10:26:44 GMT

I posted it at the main post!

Thanks for your answers

Re: No value on total

avinashelite — Mon, 13 Jul 2015 10:33:21 GMT

Hi Sab,

The Issue is with the DATA , in your expression their are lot of null values because of this even the total is appearing as null, convert the null values to zero in the script and then try , the total column will get populate

Hope this helps you

Re: No value on total

Mon, 13 Jul 2015 10:38:19 GMT

I tried it but it not work..

Re: No value on total

Mon, 13 Jul 2015 11:12:07 GMT

try with straight table it will work ,

Rather,

if we use pivot try like below if possible,

num(sum(objectif_synth)/10800,'# ##0,0 K€;-# ##0,00 €')

Re: No value on total

avinashelite — Mon, 13 Jul 2015 11:13:46 GMT

Did you handled the null values in the script? if not change the null values to 0 in the script level it will work

try changing the Pivot table to Straight table and then check?

Re: No value on total

Mon, 13 Jul 2015 11:20:06 GMT

Sorry for all my questions because i'm a beginner ahah

but where i put this instruction "num(sum(objectif_synth)/10800,'# ##0,0 K€;-# ##0,00 €')"?
In the expression?

Re: No value on total

Mon, 13 Jul 2015 13:07:08 GMT

Hi,

You need to put it under expression & then under NUMBER tab select Expression Default,

=num(sum(objectif_synth)/10800,'# ##0,0 K€;-# ##0,00 €')

Re: No value on total

Mon, 13 Jul 2015 13:28:22 GMT

Okay that work but that changes values...

Another solution please?