Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Write an expression.

Hi,

I have a few fields like Order Number, Order Start date and Order End date.

I want to write an expression where I want to find the total number of days for a particular order number.

So that has to be

Order End date (minus -) Order start date for a given order number.

Can someone please help me with this.

Thank you.

1 Solution

Accepted Solutions
bellamae
Valued Contributor

Re: Write an expression.

If your data is all on the same line then [Order End date]-[Order Start date] should work fine

5 Replies
MVP
MVP

Re: Write an expression.

I think what you have seems to be right, are you not getting the desired output?

Not applicable

Re: Write an expression.

Hi Sunny,

No I am not getting any output. It is blank. I tried to write an expression under create multi box.

bellamae
Valued Contributor

Re: Write an expression.

If your data is all on the same line then [Order End date]-[Order Start date] should work fine

Not applicable

Re: Write an expression.

I got it

Thank you.

Not applicable

Re: Write an expression.

I got it.

Thank you.