topic Expression help in QlikView

Expression help

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

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

trdandamudi — Wed, 28 Sep 2016 15:36:11 GMT

May be as below:

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

vishsaggi — Wed, 28 Sep 2016 15:36:35 GMT

Did you try this ?

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

sunny_talwar — Wed, 28 Sep 2016 19:03:52 GMT

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