Layout issue in qlikview pivot

[santoshrai]

Hi,

It will be great help to me if somebody help me sort this issue.

In qlikview pivot, one can adjust the expression layout based on dragging it at column level or row level,

But in depends on type of data. But i need some help to adjust the layout.

Background :

i have two expression Business (fy 16-17) & New rate (month wise).

Business is one value for whole year (irrespective of numbers of entries or new rate), while new rate has more the one entry.

if i tried pivot in qlikview, i will get output as pic 1 & pic 2....

while i would like to have output as pic 3

Pic 1

PIC2

PIC 3

[Peter_Cammaert]

You can do this by creating a calculated dimension that groups the current set of "New rate" dates with a single artificial value of "Business fy 16-17". A single expression using an IF() that checks on the current dimension value, either the business expression will be used or the New rate expression. I'll see if I can find an example.

Peter

[Chanty4u]

can u share the sample app?

[kkkumar82]

Hi,

Can you attach a qvw with some dummy data.

Thanks

Kiran Kumar

[kkkumar82]

If I am correct you have to make changes in the data model to make one of your fact as dimension so that you can pivot it.

Kiran Kumar

[Gysbert_Wassenaar]

You will need a dimension that contains the values Business and New rate. And you will need a dimension that contains the values of the months and the value fy 16-17. And you need a table that associates the Business value with fy 16-17 and the months with the value New rate. You can find an idea of what I mean here: Calculation of FY-MOMTD(Month on Month Till date)

Can you post a small qlikview document with example data?

[Peter_Cammaert]

It may not look like it, but this discussion will give you a clue about how to create an artificial dimension value and act upon it: Average help