Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Shubham_Deshmukh
Valued Contributor

Append columns with merged columns in PIVOT Table

See I have raw data(Can't share) and  one date on which date dimension is dependent. I want suggestions on the scenarios.

Pls refer: Excel_1.xlsx (Complete Report) or IMG1

Untitled.png

Now, I know using Pivot we can create report like Excel_2.xlsx or IMG 2.

Untitled.png

But in report, there is extra part like (Excel_3.xlsx) with Excel_2.xlsx part which I think I can't append with Excel_2.xlsx in PIVOT Table.Pls refer : Excel_3.xlsx or IMG 3 below

Untitled.png

Kindly suggest me about the approach,

1> Can we create such report in same table?

2> Is it standard way to split the report(IMG 1) into 2 reports (IMG 2, IMG 3)?Because by splitting them I think we can develop it.

2 Replies
Highlighted
Partner
Partner

Re: Append columns with merged columns in PIVOT Table

Hi,

Since they are different dimensions (or even calculated dimensions), you have two options;

1. Create separate charts. Takes little effort but doesn't look like your example (IMG1)

2. Use ValueList() function to create your chart using a calculated dimension. Takes a bit more effort and requires you to think about how you want to make it dynamic (what selections impact the dimension values and how etc).

Highlighted
Shubham_Deshmukh
Valued Contributor

Re: Append columns with merged columns in PIVOT Table

I agree, I will have to use it with calculated dimension but then also Column merging like IMG_1 won't be possible.