Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking two feilds by formula

Good day,

I have a prolem linking two two tables using a formula.

In our business we have orders to deliver by a specific date.

I want to create a list box showing me the number of days remaing to deliver the orders. (deliver by date-order date=answer)

Attached herewith is a sample of a few orders and their respective dates, also QV model is attached as well.

Please could you assit me in achiving this.

3 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

have you tried to add a chart, set straight table, added the dimensions (Customer and Order) and then the expression (deliver by date-order date)?

Not applicable
Author

Hi,

I did exactly that, but I want to do it in the background not front end.

As I want to also add a list box for number of days till delivery expected which would come from deliver by date-order date.

When I do what you proposed it works on the Straight Table in the front end if I make the expression (deliver by date-order date) but then when I make a list box from that calculated dimension it does not seems to relate.

This is for the warehouse to check outstanding orders, but I want them to look at it in order of importance which needs to be delivered first, thus he would choose orders with no invoice for the month we in, sort that table by number of days to deliver.

But it brings up -13 days 0 days etc as it brings in old orders we missed, so I want a list box where I choose 1 days or 2 days thus only seeing what truly needs to be supplied.

Kind regards

Matthew Raschke

Email: matthew.raschke@ellies.co.za

Tel: +27 11 490 3893

Cell: +27 82 318 5051

www.ellies.co.za <http://www.ellies.co.za> <http:// <http://> www.ellies.co.za/>

94 Eloff Street Ext, Village Deep,

Johannesburg,2001, South Africa.

The only place success comes before work is in the dictionary

P please consider the environment before printing this email

Not applicable
Author

I hope you can see pic below, the list box does not have any fields to select all greyed out ?

Kind regards

Matthew Raschke

Email: matthew.raschke@ellies.co.za

Tel: +27 11 490 3893

Cell: +27 82 318 5051

www.ellies.co.za <http://www.ellies.co.za> <http:// <http://> www.ellies.co.za/>

94 Eloff Street Ext, Village Deep,

Johannesburg,2001, South Africa.

The only place success comes before work is in the dictionary

P please consider the environment before printing this email