topic Re: Help in expression in QlikView

Help in expression

ali_hijazi — Fri, 11 Aug 2017 09:12:28 GMT

Hello

Check attached qvw file

I have an expression that is giving correct results:

the expression is in the text object labelled current selection

on the left I have another text object and I want to show the result of 2016 while selecting 2017

but it is giving me zero

please advise

tresB — Fri, 11 Aug 2017 10:47:06 GMT

Try:

=sum( {<YEAR={$(=max(YEAR)-1)}>}

aggr

(DISTINCT

sum

(

{

trx_type={'sales_forecast'},

price_category={'default_product_price'},

YEAR={$(=max(YEAR)-1)}

}

if(trx_date>= from_period and trx_date <= to_period, price_kg)

)

,account_company_key,MONTH_YEAR,customer_key,product_key,account_row_id

) )

ali_hijazi — Fri, 11 Aug 2017 11:40:28 GMT

look this doesn't work cause I'm using the expression inside Alt function without sum(aggr(sum....

is there a way to avoid if else and put something in set analysis that gives same result?

ali_hijazi — Fri, 11 Aug 2017 13:35:19 GMT

yes your suggestion works fine however the complete result is not working well