topic Maximum Date in QlikView

Maximum Date

Mon, 17 Nov 2014 06:27:35 GMT

Dear all,

i have date wise sale qty. how can i find sales qty with maximum date.

Regards,

Masba

Re: Maximum Date

anbu1984 — Mon, 17 Nov 2014 06:28:39 GMT

=Firstsortedvalue(Qty,-Sales_date)

Re: Maximum Date

Mon, 17 Nov 2014 06:40:26 GMT

In case you want in Text box , you can use set expression i.e. sum({$<Sale_Date ={$(=max(Sale_Date))} >}Qty)

Re: Maximum Date

morgankejerhag — Mon, 17 Nov 2014 06:43:03 GMT

How will you be using the value? If it is in a table with Date as a column then you could do:

if(Date=max(total Date),sum(Qty),0)

See attached example

Re: Maximum Date

Mon, 17 Nov 2014 06:45:05 GMT

hey masba,

vSaleDate=max(sale_date)

=only({<sale_date={"$(vSaleDate)"}>}qty)

cheers,

kunal bhattacharjee

Re: Maximum Date

jagan — Mon, 17 Nov 2014 06:45:29 GMT

Hi,

Check this expression

sum({$<Sale_Date ={'$(=Date(Max(Sale_Date)))'} >}Qty)

Note: Sale_Date and Today() date format should be in the same format.

Regards,

Jagan.

Re: Maximum Date

ashfaq_haseeb — Mon, 17 Nov 2014 06:50:31 GMT

Try this

=sum({$<Sale_Date={'$(=max(Sale_Date))'} >}Qty)

Regards

ASHFAQ

Re: Maximum Date

Mon, 17 Nov 2014 06:59:24 GMT

Dear Morgan ,

Thnx for ur reply.. your suggestion is working simple table .. but my problem is that in my chart X axis will display maximum date and Y axis will show sum(qty)..

Regards,

Masba

Re: Maximum Date

ashfaq_haseeb — Mon, 17 Nov 2014 07:03:42 GMT

You can change the chart type?

What chart type are you using?

Regards

ASHFAQ

Re: Maximum Date

Mon, 17 Nov 2014 07:11:46 GMT

assign max(sales_date) to a variable then only{$ <Vsals_data>qty}

Re: Maximum Date

morgankejerhag — Mon, 17 Nov 2014 07:19:15 GMT

Hello again,

Should it only have one bar? Then you can simply change chart type.