topic Re: Help in QlikView

Help

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Help

Anonymous — Thu, 05 Jan 2017 15:24:02 GMT

Try

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

Re: Help

panipat1990 — Thu, 05 Jan 2017 15:26:30 GMT

Not working

Re: Help

vinieme12 — Thu, 05 Jan 2017 15:39:50 GMT

TRY

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

Re: Help

vinieme12 — Thu, 05 Jan 2017 15:46:53 GMT

panipat1990

please close the thread if your query is resolved

Re: Help

panipat1990 — Thu, 05 Jan 2017 15:51:13 GMT

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

sunny_talwar — Thu, 05 Jan 2017 16:11:01 GMT

Like this?

Re: Help

panipat1990 — Thu, 05 Jan 2017 17:16:44 GMT

Dear Sunny,

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

Re: Help

sunny_talwar — Thu, 05 Jan 2017 17:21:58 GMT

Try this:

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

Re: Help

panipat1990 — Thu, 05 Jan 2017 17:26:41 GMT

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

Re: Help

sunny_talwar — Thu, 05 Jan 2017 17:32:06 GMT

panipat1990‌ sir kindly provide your application and be less dependent on people here. I am helping out here because I want, not because I get paid

I hope you will understand

Best,

Sunny

Re: Help

panipat1990 — Thu, 05 Jan 2017 17:39:34 GMT

Dear Sunny

Here i am attaching my app

Re: Help

sunny_talwar — Thu, 05 Jan 2017 17:49:55 GMT

Try this:

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

Re: Help

panipat1990 — Thu, 05 Jan 2017 18:22:35 GMT

Kindly can you send me the app where you written this code.

Re: Help

sunny_talwar — Thu, 05 Jan 2017 18:25:20 GMT

Here you go (sorry I thought I attached it earlier)

Re: Help

panipat1990 — Thu, 05 Jan 2017 18:31:17 GMT

If i created for Oct sep Aug Jul Jun May Apr

Then only in your code -1,-2,-3,-4,-5 Only i will have to do this

Re: Help

sunny_talwar — Thu, 05 Jan 2017 18:37:15 GMT

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])