topic Re: Expression help please in QlikView

Expression help please

Wed, 25 Nov 2020 16:16:04 GMT

I have below expression in staright table and Total count and expression total are giving different counts.Can anyone help me make it right ?

IF(SUM([Expense Amount (USD)]) > '75000',

IF([Year of Expense] =YEAR(TODAY()),COUNT(%LeaseKey)))

sunny_talwar — Thu, 11 Aug 2016 15:16:37 GMT

Yes they will give different results based on the option you choose. Which one do you want to use?

Simon_J — Thu, 11 Aug 2016 15:19:04 GMT

Hi Pavana

Is this due to the dimension you have in the table. Are there any null rows suppressed in the table?

Thanks

Simon

Thu, 11 Aug 2016 15:25:06 GMT

I need both the filters in the expression.Basically I have to show the Count of LeaseKey's where current year sum(Expense) greater than 75k.

Anonymous — Thu, 11 Aug 2016 15:34:48 GMT

try this as an expression in a PIVOT TABLE ?

COUNT( { <[ Year of Expense] = {"$(=Year(Today()))"}, [Expense Amount (USD)]={">=75000"} > } %LeaseKey)

COUNT( Distinct { <[ Year of Expense] = {"$(=Year(Today()))"}, [Expense Amount (USD)]={">=75000"} > } %LeaseKey)

Thu, 11 Aug 2016 16:36:37 GMT

I need the sum of Expense amount...will this work as each lease has multiple rows of expense ? Thank you.