Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

chriys1337
Contributor II

Plan and rev in same row despite different dimensions

Good evening,

I have concatenated a Plan table and Actual Sales table - both have some equal fields (e.g. customer name, from, to) + some particular fields which can just be found in the one or other table (e.g. Agreement Type).

In the frontend I would like to show in  a table box all equal dimensions: customer name, from, to as well as a field which can just be found in the Plan table: Agreement Type etc. As expression the sales numbers and plan numbers should be shown in one and the same row!

Unfortunately due to the fact, that I am using a dimension which Is originally just from the one table, QlikView displays my result in 2 rows...I would like to have it in one?! (So that instad of the 0.00 in row 1, there should be 1765, and row2 is eliminated).

Unbenanntasd.PNG

Does somebody can help me please?

Thx so much, kind regards

Chris

1 Reply
MVP & Luminary
MVP & Luminary

Re: Plan and rev in same row despite different dimensions

One possibility might be to display Agreement Type not as dimension else as expression - maybe per:

only([Agreement Type])

Another solution would be to fill those fields within the script. This meant something like extracting the Agreement Type together with a key (or maybe a combined key from several fields) from the plan-table into a mapping-table and then calling this value per applymap() with your sales-load.

- Marcus