topic Re: Values in Text box in QlikView

Values in Text box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How to show max order date in text object and respective order number of that order date.

Thanks

Re: Values in Text box

ecolomer — Mon, 27 Feb 2017 05:03:47 GMT

= date(max(DATE), 'YYYY/MM/DD')

Re: Values in Text box

Anonymous — Mon, 27 Feb 2017 05:06:34 GMT

I need order date with order number

Re: Values in Text box

Anonymous — Mon, 27 Feb 2017 05:12:34 GMT

In chart it is showing 23-02-2017 with order number and in text box i am getting 24-02-2017 order date

Re: Values in Text box

shivkumar300 — Mon, 27 Feb 2017 05:14:24 GMT

Hi,

use below expression

=OrderNo&'

'&max(date(OrderDate))

it is over all max date

after selection it's showing order no and max order date

Re: Values in Text box

Anonymous — Mon, 27 Feb 2017 05:31:04 GMT

Any ideas ??? ??

Re: Values in Text box

rahulpawarb — Mon, 27 Feb 2017 05:56:40 GMT

Hello Vijay,

Trust that you are doing well!

Please refer below given steps:

1. Create a variable to store value of Max. Order Date

//vMaxOrderDate (with current selection)
=Max(OrderDateKey)

2. Create Text Object with following definition (This will return latest OrderNumber associated with provided OrderDateKey)

='Max Order Date: ' & $(vMaxOrderDate)  & Chr(10) &
'Max Order Id: ' & Max({<OrderDateKey={"= $(vMaxOrderDate)"}>}OrderNumber)

Hope this will be helpful.

Still if you are facing some challenges then let me know.

Regards!

Rahul

Re: Values in Text box

Anil_Babu_Samineni — Mon, 27 Feb 2017 06:02:28 GMT

Would you provide detail with Dates and expected result in Text box?

May be floor can help you to remove null values of association. I am not sure how was your data

Re: Values in Text box

Anonymous — Mon, 27 Feb 2017 06:16:41 GMT

I tried but Order id is not coming and order date is showing 24-02-2017 but my last order date is 23-02-2017

Re: Values in Text box

jonathandienst — Mon, 27 Feb 2017 06:28:21 GMT

Then it is clear that you have dates against which there are no orders. This is not necessarily an error, but it does affect how you would determine the latest order date. You will need a set expression filter to consider only dates with orders. Something like this:

=Date(Max({<OrderID = {'*'}>} Date))

For the OrderID, you could use

=FirstSortedValue(OrderID, -Date)

=Only({<Date = {"$(=Date(Max({<OrderID = {'*'}>} Date)))"}>} OrderID)

=Concat({<Date = {"$(=Date(Max({<OrderID = {'*'}>} Date)))"}>} DISTINCT OrderID)

=Max({<Date = {"$(=Date(Max({<OrderID = {'*'}>} Date)))"}>} DISTINCT OrderID)

The correct one depends on your specific requirements and data model. Adapt to fit.