5 Replies Latest reply: Dec 27, 2016 10:56 PM by marco hadiyanto

Expression doesn't work (

Hello, again, friends!

Yesterday i ask you to (Help with expression)

I simplified condition - now i need to take sum of sales on this: BVRPBEDVTZ >= VTRBEGDVTR + 1 year.

And now it looks like this:

Sum(

{<

t35PRDWAER = {'RUB'},

>}

DECNRPRDEC)

But it still doesn't work , AddYears() function is become gray in code

Example in attach

• Re: Expression doesn't work (

Hi Vasiliy,

If you want to get result

Sum(

{<

t35PRDWAER = {'RUB'},

>}

DECNRPRDEC)

The value of your set analysis won't return 1 single value so BVRPBEDVTZ return nothing, that's why i adding max so i get 1 single value.

Regards,

Marco

• Re: Expression doesn't work (

sure i compare this dates now is ssms

• Re: Expression doesn't work (

i decided to make new field Flag which contains when payment make

so now i need to thing how to divide this two sum(sales) into 2 KPI in qlik sense: first year payments and next years

upd: and i find the decision

i use

1. Sum({<t35PRDWAER = {'RUB'}, FlagYearPayment = {'next'}>} DECNRPRDEC) for next years payments

2. Sum({<t35PRDWAER = {'RUB'}, FlagYearPayment = {'first'}>} DECNRPRDEC) for first year payments

still search for decision un expressions in qlik sense...

• Re: Expression doesn't work (

Hey, Marco! Youк thoughts about compare this 2 fields with dates hepls me to find the right solution! Cheers!

• Re: Expression doesn't work (

Hi Vasiliy,

Cheers!

It's better to compare on script level and it's easier rather than we search how set analysis works.

Regards

Marco