matchas
Contributor II
2022-09-16
06:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Thank you.
Labels (7)
Labels
- Subscribe by Topic:
-
Application Development
-
Client Managed
-
Creating Analytics
-
Layout & Visualizations
-
Other
-
SaaS
-
Scripting
542 Views
1 Reply
marcus_sommer
MVP
2022-09-19
01:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
507 Views