Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
yashcena
New Contributor II

Show Max Value in Pivot Chart

Hi,

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

Capture.JPG

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.


Capture2.JPG


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




3 Replies

Re: Show Max Value in Pivot Chart

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

yashcena
New Contributor II

Re: Show Max Value in Pivot Chart

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

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


Capture.PNG