topic Re: Sum Null in QlikView

Sum Null

pgalvezt — Mon, 27 Aug 2012 15:23:59 GMT

Hi, I don't know if QlikView can do this. But What I want is take all values to the first row in INP. Should be just all together

Inp -

9662927957 -

- -

Total

9662927957 -

So after that I can delete nulls.

Thanks

Re: Sum Null

pgalvezt — Mon, 27 Aug 2012 16:11:00 GMT

Any Help?

Re: Sum Null

whiteline — Mon, 27 Aug 2012 16:36:29 GMT

You can Create fake dimension with one value "Inp" (="Inp").

So that it's not connected with your data, the sum expression will return one value 9662927957.

Re: Sum Null

pgalvezt — Mon, 27 Aug 2012 16:45:38 GMT

Im sorry I forgot to tell you that I have more Clients is not just Inp. So When I created On Dimmension Tab Add Dimmension Calculated ='Inp'. In my chart appear:

Client 1 Client 2 Inp -

Inp Inp Inp Inp

And return the same result.

Re: Sum Null

whiteline — Mon, 27 Aug 2012 17:02:24 GMT

Ok. I can't see other dimensions, your data model and so on, so its hard to suggest something useful.

Please describe what are you trying to achieve ?

Re: Sum Null

pgalvezt — Mon, 27 Aug 2012 17:31:59 GMT

QlikView is show me a column null lile - But thouse values goes into Inp. I need a unique total Inp. the rest of clients are good. For security I deleted the others clients. See the attached please.

Re: Sum Null

whiteline — Mon, 27 Aug 2012 18:02:13 GMT

Use this as calculated dimension: =if(isnull(DimName), 'Inp', DimName)

"DimName" is your dimension name, so there is only "Com..." on the screenshot.

Re: Sum Null

pgalvezt — Mon, 27 Aug 2012 18:10:55 GMT

Works fine, but How Still show values I need I unique value. The idea is

Inp

962927057 in the first row where is 9517085701

Thank you.

Re: Sum Null

whiteline — Mon, 27 Aug 2012 18:29:42 GMT

It's because "Inp" also has "Tramos" dimension.

You can use =if(DimName='Inp', 'Tramo 0', Tramos) instead "Tramos" as calculated dimension.

This keeps only 'Tramo 0' value for 'Inp'.

Re: Sum Null

pgalvezt — Mon, 27 Aug 2012 19:42:44 GMT

Appears the same shape.

Re: Sum Null

whiteline — Mon, 27 Aug 2012 19:47:13 GMT

So you cann't attach the whole file, please paste dimension formulas that you use now.

Re: Sum Null

pgalvezt — Mon, 27 Aug 2012 19:56:42 GMT

For Tramos

if(Comercio='Inp', 'Tramo 0', Tramos)

For Comercio

if(isnull(Comercio), 'Inp', Comercio)

Re: Sum Null

whiteline — Mon, 27 Aug 2012 20:19:14 GMT

For Tramos you shoud use:

=if(Comercio='Inp' or isnull(Comercio), 'Tramo 0', Tramos)

Because all null Comercio also replaced with 'Inp'.