Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
panipat1990
Contributor II

Help

Dear Team,

i stuck a requirement. i have data oct, nov dec month of different dates.

in oct month i have 24/10/2016,25/10/2016,26/10/2016,27/10/2016,28/10/2016

In Nov Month i have 26/11/2016,27/11/2016,28/11/2016,29/11/2016,30/11/2016

In Dec Month i have 11/12/2016,12/12/2016,13/12/2016,14/12/2016,15/12/2016,16/12/2016

For this i am sharing a qvd where all data exit with date.

i want to show only each month of maximum date wise Avl Value.If i see in oct month then it show only 28/10/2016 date regarding value

If i see in Nov month then it show 30/11/2016 date regarding value

If i see in Decmonth then it show 16/12/2016  date regarding value

How is it.Kindly Help Me For soliving this issue. Maximum date of each month

1 Solution

Accepted Solutions

Re: Help

Yes

=Sum({$<Link_Date={$(=Chr(34) & Date(Max({$<Link_Date={"<$(=Date(MonthStart(Max(Link_Date), -1), 'DD/MM/YYYY'))"},[Fiscal Month]>} Link_Date),'DD/MM/YYYY') & Chr(34))}, [Fiscal Month]>} [Avl Value])

16 Replies
adrianbuzer
Contributor II

Re: Help

Try

sum( {<Date={$(=max(Date))}> Value }

panipat1990
Contributor II

Re: Help

Not working

vinieme12
Esteemed Contributor II

Re: Help

TRY

sum( AGGR(if(DATE = Max(TOTAL <MONTHIS> DATE) ,Amountt),MONTHIS,DATE))

vinieme12
Esteemed Contributor II

Re: Help

panipat1990

please close the thread if your query is resolved

panipat1990
Contributor II

Re: Help

i will close. But This code is not running.

I tell you. i make a straight table.

My dimension is article and My First measure is Current month's max date wise Value like Sum({<Link_Date={Max(Link_Date)}>}Value

But when i Make Second measure for last month then what i write for maximum date for last month.

Same As Previous  to month

Re: Help

Like this?

Capture.PNG

panipat1990
Contributor II

Re: Help

Dear Sunny,

i am attaching a calendar qvd.then write code. when i am using this is not working

Re: Help

Try this:

Sum({$<DATE={"$(=Date(Max({<DATE = {'<$(=MonthStart(Max(DATE)))'}, Month, [Avl Value] = {'*'}>} DATE)))"}, Month>} [Avl Value])

panipat1990
Contributor II

Re: Help

But i am using the fiscal month and i am left keep using in data model when i associate the calendar. and

i am using date format DD/MM/YYYY..Kindly use this and then write code

Community Browser