topic Re: Pivot Table with bars in QlikView

Pivot Table with bars

Wed, 25 Nov 2020 16:16:04 GMT

Hey,

unfortunately I fail creating such a visually looking table:

Data available:

Companyname	Year	Question1	Question2	Question 3
aaa	2014	325	..
aaa	2013	321
aaa	2012	231
bbb	2014	111
bbb	2013	222
bbb	2012	333		...

And here is the basic idea what to calculate and so on:

Anyway, no idea how to create such a table that looks like the above...

Many thanks!

Re: Pivot Table with bars

swuehl — Fri, 11 Mar 2016 22:09:09 GMT

The above screenshot is probably just showing a plain pivot table chart with two dimensions like Category and SubCategory, an expression to show a percentage and next to an expression showing a linear gauge (using display option 'Linear gauge' on expression tab), then two other expressions for change and total share.

You can see a similar example in Rob Wunderlich blog, survey table example:

Pivot Table Grids | Qlikview Cookbook

(downloadable sample files)

If you need more help, you would need to post some sample data, best in a small sample QVW.

Hope this helps,

Stefan

Re: Pivot Table with bars

Tue, 29 Mar 2016 13:05:11 GMT

Thanks!

I wanna use the Survey Results grid from Rob Wunderlich.

The issue is that my data set is structured differently and I am not able to configure the table dimensions to visualize the above sample data as it is in Wunderlichs example.

Could anyone try that?

Re: Pivot Table with bars

swuehl — Tue, 29 Mar 2016 13:35:38 GMT

Could you post a small sample QVW?

Re: Pivot Table with bars

Tue, 29 Mar 2016 13:44:34 GMT

I don´t have any other sample than the one of Rob Wunderlich.

Re: Pivot Table with bars

swuehl — Tue, 29 Mar 2016 13:57:55 GMT

I am talking about a sample of your data set.

Re: Pivot Table with bars

Tue, 29 Mar 2016 14:05:04 GMT

Find attached some sample data.

Re: Pivot Table with bars

swuehl — Tue, 29 Mar 2016 16:39:31 GMT

You can transform your excel table using CROSSTABLE into a straight table to match the data model Rob has used:

CrossTable (Question, Answer,2)

LOAD Year,

Companyname,

[Question 1],

[Question 2],

[Question 3],

[Question 4]

FROM

(ooxml, embedded labels, table is Tabelle1)

WHERE Len(trim(Companyname));