Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

pivot table columns

Hi guys,

In my pivot table, I want to put in 2 columns, but with the same dimension. Is that possible?

Thanks for help!

4 Replies
OmarBenSalem
Esteemed Contributor

Re: pivot table columns

sthing like this??

dim1: UrDimension

dim2: aggr(only(UrDimension),UrDimension)

Capture.PNG

yujiyamane
Contributor II

Re: pivot table columns

Hi Wanyun,

Yes, it is possible as per below image.

Is it what you wanted?Capture.PNG

wanyunyang
Contributor

Re: pivot table columns

In your example, I mean like Apple, Microsoft, Yahoo, 2016,2017,2018

yujiyamane
Contributor II

Re: pivot table columns

I see. That is very good question.

I cannot think of any idea to do that.. Let's wait to hear what other experts would say.

This could be done in QlikView by using multiple objects but it is tricky.

Community Browser