topic Re: how to show last records from data. in QlikView

how to show last records from data.

rupaliqlik — Sat, 16 Nov 2024 21:14:10 GMT

Hi All,

I have march month data for date 1 to 15,but till 10 we have data and 11 to 15 we don't have records, only date 's are coming.So basically I have to show only last day records which came on 10th march.How to retrive sales for last records in set analysis expression.

Thanks,

Rupali Ethape

sunny t

Re: how to show last records from data.

Shubham_Deshmukh — Fri, 15 Mar 2019 10:37:24 GMT

Try this :

=MaxString({<dates={"=$(=max(dates))"},sale -={''}>}sale)

// -= (dash equal) is used for not equal

Re: how to show last records from data.

amrinder — Fri, 15 Mar 2019 10:43:29 GMT

You can do it in two ways either restrict data from 11 Mar in script only. Another way is to add flag in script and in front end create variable based on max date and Flag created and then pass that variable in set expression on date basis.

-amrinder

Re: how to show last records from data.

rupaliqlik — Fri, 15 Mar 2019 11:58:44 GMT

Hi,

But It is giving correct value in textbox, not in chart.I want to display it in chart level

Re: how to show last records from data.

sunny_talwar — Fri, 15 Mar 2019 12:00:54 GMT

May be this

Sum({<Date = {"$(=Max({<Sales = {[*]}>}Date))"}>}Sales)

Re: how to show last records from data.

rupaliqlik — Fri, 15 Mar 2019 12:09:36 GMT

Hi,

But It is giving correct value in text box, not in chart.I want to display it in chart level

Re: how to show last records from data.

rupaliqlik — Fri, 15 Mar 2019 12:23:34 GMT

Thanks Sunny,It's working.