Expression Calculation

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

Hi,

I have a requirement where I need to show if the revenue by part and project for any year is less than 100k or not.

Table 1

Expression for Revenue: Sum({assignmenthod-={'SaaS'}>}Revenue)

Expression for less? : If(Column(1)<=100000,'YES','NO') where column(1) is the expression for Revenue.

Table 2

I have added the quarter column in this table. As you can see when the revenue is broken down by quarter, the values for project 123 becomes less than 100,000 for each quarter and as a result gives me 'YES' for column 'Less?'. I need to show 'NO' if the total value of the project and part exceeds 100k in that year but also show it broken down by quarters. How do I achieve this? Thanks!

gwassenaar‌ jagan‌

Re: Expression Calculation

vishsaggi — Fri, 22 Jun 2018 21:09:56 GMT

May be try this? Sorry missed the dimensions

= If( Sum(TOTAL <Part, Project, Year> {< assignmenthod-={'SaaS'}, Quarter= >} Revenue) <= 100000,'YES','NO')

topic Expression Calculation in QlikView

Expression Calculation

Re: Expression Calculation