Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
matchas
Contributor II

How to Align Actual and Budget in a single line for the GL Account in a Pivot Table

Hi All,

Appreciate your suggestions in fixing the issue.

I am new to QlikView and trying to make enhancements to the existing Apps.

Question: I am trying to display Actual and Budget in a single line for the same GL Account Number of a Pviot table in Qlikview. 

matchas_0-1663366106203.png

 

Thank you.

 

1 Reply
marcus_sommer

It looked as if the content for the budget details are different - one is EMPTY and the other is probably NULL. A simple solution may be just to remove this field from the view (I doubt that these details have an added value within a comparing of actual vs. budget).

Beside of this you may consider more or less adjustment within the data-model especially in regard to the NULL handling.

- Marcus