Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Front end expression Help

Hi all ,

PFA excel . i have 3 columns - Quarter(A) , Per(B) and ISP(C) ( PFA excel ) 

I need sum of column ISP (C) where column B(Per) and Column (ISP ) is greater than 0.

How do i do that in both FRONTEND and BACKEND please help .

I tried in front end with this but its not working . Please help

=sum({<ISP={"=RangeSum(Per,ISP)>0"}>}ISP)

Value should be - 2764339

Advance thanks

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

May be try this expression

=Sum({<ISP = {">0"}>*<Per = {">0"}>}ISP)

If you want to do this in script... you can create a flag in the script

Table:
LOAD Quarter, 
     Per, 
     ISP,
     If(Per > 0 and ISP > 0, 1, 0) as Flag
FROM
[C:\Users\talwars\Downloads\DaTA.xlsx]
(ooxml, embedded labels, table is Sheet1);

and then use this expression

=Sum({<Flag = {'1'}>}ISP)

 

View solution in original post

3 Replies
sunny_talwar

May be try this expression

=Sum({<ISP = {">0"}>*<Per = {">0"}>}ISP)

If you want to do this in script... you can create a flag in the script

Table:
LOAD Quarter, 
     Per, 
     ISP,
     If(Per > 0 and ISP > 0, 1, 0) as Flag
FROM
[C:\Users\talwars\Downloads\DaTA.xlsx]
(ooxml, embedded labels, table is Sheet1);

and then use this expression

=Sum({<Flag = {'1'}>}ISP)

 

View solution in original post

kiranpatil123
Contributor III
Contributor III
Author

Thanks Sunny 
its working fine for the example which i provided 

But in my dashboard I'm getting zero .. any idea Y ?

I have attached the screen shot .

 

 

 

 

sunny_talwar

Just by looking at the screenshots... no idea