topic Re: set analysis with empty value in QlikView

set analysis with empty value

Anonymous — Thu, 19 May 2011 11:03:17 GMT

Hi.

I'm trying to get the amount for a Family thats empty ([empty]). When i do like this;

sum({$<Family={}>} Amount)

The amount is 0

But when i select the empty value there is a value. How do i do this?

Thanks,

//A.

kaushiknsolanki — Thu, 19 May 2011 11:10:45 GMT

Hi,

I am unable to understand your problem, Can you describe in detail. Or send the QVW file

Regards,

Kaushik Solanki

Anonymous — Thu, 19 May 2011 11:16:18 GMT

Sorry about that.

Ok. Let's say that we have family A, B, C, D but there's also an empty slot/value that is clickable

All familys has values (sum(Amount)).

In a table this will look like this:

A 300

B 330

C 430

D 200

320

Notice here that the last value that's empty has a value. It's this value i want to get when writing the set analysis

sum({$<Family={}>} Amount)

kaushiknsolanki — Thu, 19 May 2011 11:24:43 GMT

Hi,

I am here by sending you the sample File.

Hope this is what u r looking for.

Regards,

Kaushik Solanki

Anonymous — Thu, 19 May 2011 11:30:49 GMT

Thank you!

It worked great!

//A.

Thu, 19 May 2011 11:39:12 GMT

Hi,

use this

=sum({<Family={''}>} amt)

Regards,

Chandra