Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

unable to include variance percentage column in pivot chart

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.






error loading image

6 Replies
Not applicable
Author

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
Master II
Master II

See if this works for you.

Regards

Not applicable
Author



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
Master II
Master II

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

Regards

Not applicable
Author

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
Specialist
Specialist

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.