unable to include variance percentage column in pivot chart

[#1]

Hi,

This query is related to Pivoting

We are unable to include %Change column (shown in yellow in the below screen shot) in pivot chart after pivoting the period column.

Please suggest how to include the %Change Column.

[#2]

Hi,

I've cross checked in the community for similar thing, i found one but still it is un answered.

The below scenario looks like complex scenario, I am not sure this is possible with qlikview.

Any help greatly appreciated.

Thanks

[danielrozental]

See if this works for you.

Regards

[#4]

Hi,

Thanks for your valuable suggestion.
We have implemented the same logic in my report. But it hasnot worked out.

Function created by Daniel for

Revenue:
IF(COLUMNNO()=0,num(SUM({<PERIOD={$(=MAX(PERIOD))}>}REVENUE)/SUM({<PERIOD={$(=MIN(PERIOD))}>}REVENUE)-1,'0,00%'),SUM(REVENUE))

Profit:
IF(COLUMNNO()=0,num(SUM({<PERIOD={$(=MAX(PERIOD))}>}PROFIT)/SUM({<PERIOD={$(=MIN(PERIOD))}>}PROFIT)-1,'0,00%'),SUM(PROFIT))

Please see the below screenshot.
Final report generated by using the above functions.
The %change column is showing in the 0.00. We are not getting the proper values in the %change column.

Additional information:
As we have seen your report - taking the fields from the same table.
But we are taking fields[Revenue/Profit] from different tables. Is this is the causing the issue?

Any help greatly appriciated.

Thanks,

[danielrozental]

change de num format from 0,00% With a comma to 0.00% with dot.

Regards

[#6]

Hi Daniel,

I have changed as you said , But there is no change in o/p except ( . ) in place of ( , ) as like in the below screen shot

But the expresiion you have created in the example abc.qvw is if we have 2 dimensions (PeridId & Sub Region)
Is there any thing we need to change in the expression level, as you can see in the screen shot there is one more dimension Region Name.

Is something to be changed in expression?

[nathanfurby]

Daniel's example works fine with an extra dimension and also using values from diferent tables. There must be something wrong in your expression - you should post an example.