Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dickelsa
Contributor

Urgent question: looking back in month

Hi all,

I am building a dashboard that will show a profit and loss chart on year and month specific fields, with drilldown to costspecific dimension

(see attached files)

I want to have 2 charts:

1 chart will be responding to my selections.

Here is the catch:

The second chart will show data on every month that is before the month i selecteded.

so for example:

I select 'June'

So in the first chart i will only see my costspecific values for 'June'

Next, in the second chart, i want to see my costspecific values for every mont up to 'June' (so it will show Jan, Feb, Apr, Mar, Mai)

I want to do this without using alternate states, because other selections do have to affect the behaviour of both charts.

Also, i do not want fix this with:

Load*Inline[

Month,PreviousMonth

1,1

2.1

2,2

3,1

3,2

3,3

..]

if you see the term 'Omzet', it means Profit, and 'Kosten' means Costs.

Thanks in advance!

Best regards,

Dick

1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: Urgent question: looking back in month

Hi.

You can solve it with set analysis overriding the month selection to the =Maand<Max(total Maand).

But the presence of drill down group could be a problem.

1 Reply
whiteline
Honored Contributor II

Re: Urgent question: looking back in month

Hi.

You can solve it with set analysis overriding the month selection to the =Maand<Max(total Maand).

But the presence of drill down group could be a problem.

Community Browser