Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
matchas
Contributor II
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.

 

3 Replies
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

Jones28210
Contributor II
Contributor II

Thanks for sharing. I found a lot of interesting information here.

Pay by Plate Invoice

litebluestore
Contributor
Contributor

I can confirm that Articulate is actively working on this, but I don't have much information to provide you at the time.

LiteBlue