topic Re: Trouble with Set Analysis in QlikView

Trouble with Set Analysis

Fri, 18 Mar 2016 20:07:30 GMT

I am trying to sum the total of parts cost * Qty on hand if the part has not had any movement in Sales_8_Months AND has not been received in the last 8 months. I have the set analysis statement I have been working with and it works on most of the part number but not this one. Any help would be much appreciated.

Sum({$<Sales_8_Months={"<=0"},PART_RECEIVED_MMonth={"<=$(=Date(AddMonths(Max(PART_RECEIVED_MMonth),-8),'MMM-YY'))"}>}[Part cost - PMPCST]*[Quantity on hand - PMQONH])

Re: Trouble with Set Analysis

Fri, 18 Mar 2016 20:10:28 GMT

Correction. It is now calculating but when I click on the part number in straight table the amount disappears.

Re: Trouble with Set Analysis

amayuresh — Mon, 21 Mar 2016 07:39:53 GMT

please provide sample data.

Re: Trouble with Set Analysis

Mon, 21 Mar 2016 14:17:14 GMT

My set analysis is working if I do not select the part number. When I select the part number to show only that part number the set analysis No Movement 9 Months zeros out.

Here is where the No Movement 8 Months is showing correctly.

Here is when I select 5161419 part number it zeros out.

Here is the set analysis expression I am using.

=Sum({$<Sales_8_Months={"0"},PART_RECEIVED_MMonth={"<=$(=Date(AddMonths(Max(PART_RECEIVED_MMonth),-9),'MMM-YY'))"}>}[Part cost - PMPCST]*[Quantity on hand - PMQONH])

Thank you

Re: Trouble with Set Analysis

sunny_talwar — Mon, 21 Mar 2016 15:32:58 GMT

Not 100% certain, but can you try this:

=Sum({$<Sales_8_Months={"0"},PART_RECEIVED_MMonth={"<=$(=Date(AddMonths(Max({<[Part #]>}PART_RECEIVED_MMonth),-9),'MMM-YY'))"}>}[Part cost - PMPCST]*[Quantity on hand - PMQONH])