topic Re: Show Max Value in Pivot Chart in QlikView

Show Max Value in Pivot Chart

yashcena — Tue, 17 Jul 2018 10:05:21 GMT

Hi,

I have a chart with ResourceName and FutureWeeks as dimensions and RemainingHours as an expression.

Brief Background:

The expression is written in such a way that whenever a project ends, the average hours (which the resource had been charging) for that project is released and added to the RemainingHours (ForecastDate dimension has been dragged over the top to show it vertically).

Dana Smith:

In week of 09/02, one project ends so RemainingHours increases by 2 hours. So RemainingHours will be 9 till the time next project ends (which is in week of 09/30)

In week of 09/30, another project ends and RemainingHours increases by 7 hours. So RemainingHours will be 16 till the time next project ends. (I'm showing RemainingHours for future 26 weeks (6 months)).

My requirement is to show only those weeks where there is a change in RemainingHours.

So for above snapshot, I should get '7' for 07/15, '9' for 09/02 and '16' for 10/07.

Basically, show only the weeks where the RemainingHours change.

Is there a way to do this. I hope I have made my requirement clear.

Any help would be appreciated!

Thanks,

Yash

Re: Show Max Value in Pivot Chart

sunny_talwar — Tue, 17 Jul 2018 11:53:28 GMT

Would you be able to share a sample to try out few things?

Re: Show Max Value in Pivot Chart

yashcena — Tue, 17 Jul 2018 12:21:23 GMT

Hi Sunny,

I have added a sample app in the question. I tried using FirstSortValue but it didnt work.

I have created a copy of the chart in the test app (2 copies- one where Week is represented vertically and other where week is horizontally).

Thanks,

YASH

Re: Show Max Value in Pivot Chart

sunny_talwar — Tue, 17 Jul 2018 12:28:34 GMT

Try this for straight table

If(Alt(Above([Remaining Hours]), [Remaining Hours] - 1) <> [Remaining Hours], [Remaining Hours])

This for Pivot table

If(Alt(Before([Remaining Hours]), [Remaining Hours] - 1) <> [Remaining Hours], [Remaining Hours])