Sum Null

[pgalvezt]

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

[pgalvezt]

Any Help?

[whiteline]

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.

[pgalvezt]

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.

[whiteline]

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 ?

[pgalvezt]

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.

[whiteline]

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

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

[pgalvezt]

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.

[whiteline]

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

[pgalvezt]

Appears the same shape.