topic Table in QlikView

Table

Mon, 30 Jun 2014 08:14:59 GMT

Hi Friends,

I'd like to be able to display something like this

	MS1	MS2	MS3
Q1	1	0	1
Q2	1	0	1
Q3	1		1
Q4	1	1	1

SQL db table structure is like this

Q1	Q2	Q3	Q4	MS
1	1	1	1	MS1
0	0		1	MS2
1	1	1	1	MS3

How can i do this.

I am using the personal edition and this is first report in Qlikview.

Appreciate if some one could help me in this.

Many Thanks,

Selva

Re: Table

Gysbert_Wassenaar — Mon, 30 Jun 2014 08:22:54 GMT

You can use the Crosstable function to remodel the data:

MyTable:

Crosstable(Quarter, Value,3)

SQL Select MS, DELAER, COUNTRY, Q1, Q2, Q3, Q4

From ...mydatabasetablehere...;

Next you can use a pivot table chart object to show the data the way you want. Use Quarter and MS as dimensions and sum(Value) as expression. Expand the Quarter dimension so that the MS dimension becomes visible. Then drag the header of the MS dimension to the right and above the expression header. When you see a horizontal blue line you can let go and the MS dimension should be displayed horizontally.

Re: Table

Mon, 30 Jun 2014 08:45:36 GMT

very helpful thanks a lot Gysbert Wassenaar.

Re: Table

Mon, 30 Jun 2014 09:20:27 GMT

Hi,

How can i find the percentage for each question

	MS1	MS2	MS3	%
Q1	1	0	1	sum(1+0+1)/count(ms)
Q2	1	0	1
Q3	1		1
Q4	1	1	1

Appreciate if you could help me in this.

Thanks,
Selva

Re: Table

Gysbert_Wassenaar — Mon, 30 Jun 2014 09:24:15 GMT

Try sum(Value)/count(total <MS> Value)

Re: Table

Mon, 30 Jun 2014 09:32:32 GMT

Hi,

I am getting the table as below

I am trying to get the table like this

	MS1	MS2	MS3	%
Q1	1	0	1	sum(1+0+1)/count(ms)
Q2	1	0	1
Q3	1		1
Q4	1	1	1

Thanks,
Selva

Re: Re: Table

Gysbert_Wassenaar — Mon, 30 Jun 2014 09:40:57 GMT

See attached qvw.

Re: Table

Mon, 30 Jun 2014 09:57:20 GMT

Thanks a lot gwassenaar

Re: Table

Mon, 30 Jun 2014 10:31:53 GMT

Hi Gysbert,

I tried the expression as you mentioned. i am getting below.

i need the percentage value across each row. (Percentage value should display as column in the table)

Appreciate if you could help me in this.

Thanks,
Selva

Re: Table

Gysbert_Wassenaar — Mon, 30 Jun 2014 10:35:20 GMT

Make sure you enabled the option Partial Sums for the MS dimension on the Presentation tab.

Re: Table

Tue, 01 Jul 2014 06:49:01 GMT

Thank you Gysbert Wassenaar

I got it

Re: Re: Table

Wed, 16 Jul 2014 08:20:01 GMT

Hi Gysbert,

i am facing a problem, if one of the question is null or empty, pivot table is not displaying it. i need to display it as N/A.

Please help me.

Thanks,
Selva