Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

always last 6 months

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

Tags (4)
9 Replies

Re: always last 6 months

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

soniasweety
Valued Contributor III

Re: always last 6 months

anything is fine sunny

Re: always last 6 months

How about this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: always last 6 months

Check attached may be

soniasweety
Valued Contributor III

Re: always last 6 months

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

soniasweety
Valued Contributor III

Re: always last 6 months

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

soniasweety
Valued Contributor III

Re: always last 6 months

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

Re: always last 6 months

Seems working

Capture.JPG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: always last 6 months

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)