topic Re: Calculating sum based on a condition. in QlikView

Calculating sum based on a condition.

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm trying to find the sum of a field based on a condition that is given to another field.

example- Sum(No.of.Customers) if(Day>3 AND Day<5)

Field names-No.of.Customers and Day.

Can some one help me clear this.

MK_QSL — Mon, 26 Dec 2016 10:45:46 GMT

COUNT({<Day = {">=3<=5"} >}Customer)

SUM({<Day = {">=3<=5"} >}Customer)

Mon, 26 Dec 2016 10:52:24 GMT

That worked well, thank you so much.

Mon, 26 Dec 2016 11:10:38 GMT

I'm using this expression:

Num((((SUM({<Day = {">=3<5"} >}[No of Customers]))/(Sum([No of Customers])))*100),'##.00')

Can you tell me how to add '%' to it at last.

example- 12.45%

MK_QSL — Mon, 26 Dec 2016 11:12:37 GMT

Num((((SUM({<Day = {">=3<5"} >}[No of Customers]))/(Sum([No of Customers])))*100),'#0.00%')

Mon, 26 Dec 2016 11:18:25 GMT

When I use:

Num((((SUM({<Day = {">=3<5"} >}[No of Customers]))/(Sum([No of Customers])))*100),'##.00')

The value I get is : 28.53

But when I use :

Num((((SUM({<Day = {">=3<5"} >}[No of Customers]))/(Sum([No of Customers])))*100),'#0.00%')

It becomes : 2852.87%

MK_QSL — Mon, 26 Dec 2016 11:22:27 GMT

Sorry.. Remove * 100

Mon, 26 Dec 2016 11:37:49 GMT

Thank you very much.