topic Re: Calculation based on condition in QlikView

Calculation based on condition

Wed, 25 Nov 2020 16:16:04 GMT

1. Don't want to use aggr().

2. when a<=b-- calculate-- Sum(Sales).

output should be ---

--bav Coffe 50 (10+12+15+13)

sunny_talwar — Tue, 03 May 2016 20:56:30 GMT

What are your chart dimensions?

May be create a uniquely identifiable key in the script like this:

LOAD Product,

sub.

Sales,

AutoNumber(Product&'|'&sub&'|'&a&'|'&b) as Key

FROM Source

And then may be like this:

Sum({<Key = {"=a <= b"}>} Sales)

sunny_talwar — Tue, 03 May 2016 20:57:24 GMT

Note: This uniquely identifiable key will only work, if you have a truely unique key, else you might not see the right results.