Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
andyrebs
New Contributor II

back order visualization

Hi,

I would like to have a chart that displays backorders, but only for customers who also have an order for delivery tomorrow.

I have those two table

Cod.CusCompanyName
001Company1
002Company2
003Company3
004Company4
005Company5
006Company6
007Company7
008Company8
009Company9
010Company10
011Company11
012Company12
013Company13
014Company14
015Company15
016Company16
017Company17
018Company18
019Company19

ordN°CodCusCodArt.DeliveryDateRequiredQtyPriceStatus
Ord001Cus001Art00129/07/2013110Delivered
Ord001Cus001Art00229/07/2013212pending
Ord001Cus001Art00329/07/201349pending
Ord002Cus002Art00429/07/201313Delivered
Ord003Cus003Art00529/07/2013278pending
Ord004Cus001Art00630/07/2013112Delivered
Ord005Cus002Art00730/07/2013315Delivered
Ord005Cus002Art00830/07/20131212Delivered
Ord005Cus002Art00930/07/201331pending
Ord010Cus003Art01030/07/2013143pending
Ord011Cus001Art01131/07/2013323Delivered
Ord011Cus001Art01231/07/2013154Delivered
Ord012Cus002Art01331/07/2013412Delivered
Ord012Cus002Art01431/07/201321Delivered
Ord013Cus003Art01531/07/201333pending
Ord016Cus001Art01601/08/201314pending
Ord016Cus001Art01701/08/201375pending
Ord017Cus002Art01801/08/201341pending
Ord017Cus002Art01901/08/20131323pending

I would see only the order in status pending, but only of customers Cus001 and Cus002, because they have an order with DeliveryDateRequired tomorrow (today is 31-07-2013).

Many Thanks

Andrea

3 Replies

Re: back order visualization

hi,

see the attched application

andyrebs
New Contributor II

Re: back order visualization

Hi Kush,

many thanks for you answer. Unfortunatelly this is not what I am looking for.

In your application you use this expression

=if(Date=date(Today()+1,'DD/MM/YYYY'),Status)

It show me the orders that I have to deliver tomorrow, but not the backorders of those customers .

If it is possible, I would see not only the orders I should deliver tomorrow, but also the back orders of the customers that have an order that it should be delivered tomorrow.

andyrebs
New Contributor II

Re: back order visualization

Hi All..

Any News?