topic Re: set analysis Expression in QlikView

set analysis Expression

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

Dear community members,

I added the expression : =Sum(if('$(vStartDate)' <= '$(vEndDate)', {<TRANSACTION_DATE= {'$(vStartDate)'}>}STOCK_CONS, 0))

in a pivot table expressions, but I'm getting "-" meaning that the data is missing but I'm sure there's data.

Is there any error in the expression above?

Thank you in advance,

Abdallah

sunny_talwar — Wed, 07 Nov 2018 12:05:37 GMT

Try this

=Sum({<TRANSACTION_DATE = {'$(vStartDate)'}>} If('$(vStartDate)' <= '$(vEndDate)', STOCK_CONS, 0))

absekrafi — Wed, 07 Nov 2018 12:49:36 GMT

Thank you Sunny,

It's working.

Best regards,

Abdallah

sunny_talwar — Wed, 07 Nov 2018 12:52:44 GMT

Awesome

Please close the thread by marking the correct response above.

Thanks,

Sunny

absekrafi — Wed, 07 Nov 2018 14:43:49 GMT

Some how the "marking the correct answer" is not working right now.

I will check that later