topic Re: always last 6 months in QlikView

always last 6 months

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have an requirement like...

I have data for all years so I want to display by default max year selected and

if I select any year and any month the straight table should display previous 6months of selected month.

attached sample and excel data

sunny_talwar — Thu, 30 Nov 2017 17:05:57 GMT

You want this in straight table only? Or can we use Pivot table?

soniasweety — Thu, 30 Nov 2017 17:08:29 GMT

anything is fine sunny

Anil_Babu_Samineni — Thu, 30 Nov 2017 17:18:06 GMT

How about this?

Sum({<MonthNo = {">=$(=Max(MonthNo-6)) <=$(=Max(MonthNo))"}>} Sales)

sunny_talwar — Thu, 30 Nov 2017 17:21:45 GMT

Check attached may be

soniasweety — Thu, 30 Nov 2017 17:26:12 GMT

here one more thing I need to every month .....not totals each month product category wise I need to show.

soniasweety — Thu, 30 Nov 2017 17:28:43 GMT

like below image I need to display last six month by product category wise.

soniasweety — Thu, 30 Nov 2017 17:35:09 GMT

yes sunny ... but here when I open the application max year should be by default it is not showing any default value

and

can you explain the logic how its working ...if you don't mind..!!!!!!!1

Anil_Babu_Samineni — Thu, 30 Nov 2017 17:35:48 GMT

Seems working

Anil_Babu_Samineni — Fri, 01 Dec 2017 05:33:43 GMT

You need to assign trigger. OnOpen - Actions - Select in field - Year - Search string (=Max(Year))