Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Re: How to get the last value from a product in time

Hello,

Yes that works using the date as a Int like in this example. But in my application, Date is not like that.

The following error shows:

Error: Error in set modifier ad hoc element list: ',' or ')' expected

I've tried this but no luck:

=Sum({<num(Date)={$(=max(num(Date)))}>}#Qty)

The following error shows:

Error: Error in set modifier expression

Thanks

Highlighted
kkkumar82
Valued Contributor III

Re: How to get the last value from a product in time

Hi,

Are your dates in string format or in date format, if there are in date format

=Sum({<Date={'$(=max(Date))'}>}#Qty)



Thanks

Kiran Kumar

saran7de
Contributor III

Re: How to get the last value from a product in time

To get the Top Qty, you can also try like this..

Only({<Month={"=Rank(Month)=1"}>}Qty)

Not applicable

Re: How to get the last value from a product in time

Hello,

thanks a lot, that solved my problem.

Cheers