Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Not applicable

Combine dimensions and variable in pivot table..?

Is it possible to make a pivot table where I combine the first dimension with a variable that is not connected to another dimension?

Currently I have three dimensions: Company name, Key ratio and Year.

Right now, my table looks like this:

CompanyKey Ratio201520162017
APE15x13x11x
APB1,5x1,2x0,9x
BPE14x11x5x

And so on...

I would like to create a table that looks like this:

CompanyKey Ratio201520162017
A variable1 and variable2PE15x13x11x
APB1,5x1,2x0,9x
B variable1 and variable2PE14x11x5x

Variable1 and variable2 is only connected to dimension "Company".

3 Replies
Highlighted

Re: Combine dimensions and variable in pivot table..?

What are the VAriables you created Var1 , Var 2?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Not applicable

Re: Combine dimensions and variable in pivot table..?

Var1 is the reqired return for the company and Var2 is the potential return. Both Var1 and Var2 is retrived from separate excel sheets. I was thinking about a way to do it in excel: ="DIV @ "&TEXT(R[20]C[1];"0,00") will show DIV @ 22,00 and I want to do something similar in QlikView so i get Company A: 14,5% & 60%

Highlighted
MVP & Luminary
MVP & Luminary

Re: Combine dimensions and variable in pivot table..?

I think I would create additional fields from the variables and then combining those fields within the script or within gui.

- Marcus