topic unable to include variance percentage column in pivot chart in QlikView

unable to include variance percentage column in pivot chart

Wed, 11 Aug 2010 10:51:01 GMT

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.

unable to include variance percentage column in pivot chart

Thu, 12 Aug 2010 14:22:31 GMT

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

unable to include variance percentage column in pivot chart

danielrozental — Thu, 12 Aug 2010 19:20:30 GMT

See if this works for you.

Regards

unable to include variance percentage column in pivot chart

Fri, 13 Aug 2010 11:23:48 GMT

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,

unable to include variance percentage column in pivot chart

danielrozental — Fri, 13 Aug 2010 19:13:14 GMT

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

Regards

unable to include variance percentage column in pivot chart

Mon, 16 Aug 2010 16:03:03 GMT

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?

unable to include variance percentage column in pivot chart

nathanfurby — Tue, 17 Aug 2010 09:04:11 GMT

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.