topic Re: Layout issue in qlikview pivot in QlikView

Layout issue in qlikview pivot

santoshrai — Fri, 25 Mar 2016 07:04:53 GMT

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

Re: Layout issue in qlikview pivot

Peter_Cammaert — Fri, 25 Mar 2016 07:38:37 GMT

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

Re: Layout issue in qlikview pivot

Chanty4u — Fri, 25 Mar 2016 07:41:40 GMT

can u share the sample app?

Re: Layout issue in qlikview pivot

kkkumar82 — Fri, 25 Mar 2016 07:42:29 GMT

Hi,

Can you attach a qvw with some dummy data.

Thanks

Kiran Kumar

Re: Layout issue in qlikview pivot

kkkumar82 — Fri, 25 Mar 2016 07:48:21 GMT

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

Re: Layout issue in qlikview pivot

Gysbert_Wassenaar — Fri, 25 Mar 2016 07:51:57 GMT

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?

Re: Layout issue in qlikview pivot

Peter_Cammaert — Fri, 25 Mar 2016 08:06:21 GMT

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