Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Expression help

I have the below expression.

count( {<  Key = {"=sum([Amount (USD)]) >90000"} >} ID)

Here Amount USD is combination of Expense & Revenue So I want to Only include Expense which is greater than >90000.

Can I add that If statement within the above expression ?

I have a column called Type which  has Expense and Revenue.

sum(if(Type='Expense',Amount (USD)))

Thanks Much

3 Replies
trdandamudi
Master II
Master II

May be as below:

count( {<  Type={'Expense'},Key = {"=sum([Amount (USD)]) >90000"} >} ID)

vishsaggi
Champion III
Champion III

Did you try this ?

count( {<  Key = {"=sum({< Type = {'Expense'}>}[Amount (USD)]) >90000"} >} ID)

sunny_talwar

I agree with Vish. His expression should work for you.