Qlikview script not working correctly .

[suvechha_b]

Hi All ,

Please advise why the product is allocating to NULL distributor as though the distributor should be 'PIN' with qty_avaiable '32868' for warehouse 'W10'.

sample attached.

Please advise why the "Prev 3 month sales units " is not working in the sample model.

[felipedl]

As i stated before,

https://community.qlik.com/thread/262901

the period_key on the table doesn't have the necessary values for the expression your calculating (see the image below, with the markings).

You have to understand in your data, as to why only period_key with value 190 is being loaded.

Felipe.

[vinieme12]

because your Distributor_Link field is not associated to your data model