topic Re: Set Expression in QlikView

Set Expression

upaliwije — Fri, 10 Jan 2020 06:35:09 GMT

Dear Friends

I have written below expression in my pivot table but it returns zero values

sum({<ORDER_QTY={">0"},SUPPLIER=>}STOCK_BALANCE)

Is there any error in it if so pls correct me else pls suggest an alternative solution

Thanks in advance

Re: Set Expression

Arthur_Fong — Fri, 10 Jan 2020 07:04:20 GMT

You have a sample app?

Re: Set Expression

upaliwije — Fri, 10 Jan 2020 07:19:55 GMT

Yes I attach h/w my issue is with first column(stock in hand)

Re: Set Expression

tresB — Fri, 10 Jan 2020 07:52:10 GMT

It's not a problem with your expression but data. If you select all ORDER_QTY field values (>0), you would see there is no value associated in STOCK_BALANCE (all values are grayed out).

Re: Set Expression

Arthur_Fong — Fri, 10 Jan 2020 08:33:04 GMT

A better understanding on the post @tresB has replied, your data is not linked:

When order quantity > 0, there is no stock balance to be calculated. Hence expression returned 0.

I guess your data model is done by concatenating both tables together, which in this case not applicable.

You might need to associate using link key or joining both table together, provided each record has a unique key.

Re: Set Expression

Brett_Bleess — Mon, 10 Feb 2020 21:31:39 GMT

Were you able to get things sorted out with help from either of the posters? If so, do not forget to return to the thread and use the Accept as Solution button to mark the post(s) that helped, you can mark more than one if both were helpful... If you still need assistance, please leave an update, but please do one or the other, and if you did something different, you can post that and mark that too.

Regards,
Brett