topic Re: P() and E(). Set analysis in QlikView

P() and E(). Set analysis

MindaugasBacius — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

There is a code:

Load *
Inline [
Sale, Supplier, Category
1, RA112, A
2, RA112, B
3, RA112, A
4, RA114, A
];

There is a locked filter Category that I would like to ignore while other filters should remain.

The final TextObject result should be 6.

Thank you!

skovsgaard — Thu, 14 Jul 2016 08:19:25 GMT

The following expression should give you the correct result.

sum({$<Category = >}Sale)

PrashantSangle — Thu, 14 Jul 2016 08:49:46 GMT

or nullify that selection.

like this

=sum({<Category=>}Sale)

Regards,