Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Qlikview script not working correctly .

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'.Capture1.PNG

Capture2.PNG

sample attached.

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

Capture3.PNG

2 Replies
felipedl
Partner
Partner

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.

Sample2.png

Felipe.

vinieme12
Champion II
Champion II

because your Distributor_Link field is not associated to your data model