topic Re: Pivot Table query in QlikView

Pivot Table query

saumyashah90 — Wed, 11 Mar 2015 15:42:35 GMT

Hi Guyz,

I have application in column named a,b,c,d.

I have page in column names 1,2,3,4

So one application will have page

1-> b,c

2 -> b,d

3 -> a,c

Now I want to check a person is going From what function of parameters To what function of parameters.

Source App	Source Page	Destination App	Destination Page
1	b	2	b
1	c	3	c

Should I make 2 more column with different names or can we do it in some other way?

Re: Pivot Table query

Gysbert_Wassenaar — Wed, 11 Mar 2015 17:47:03 GMT

I don't understand your question. Can you post a source table and a result table?

Re: Pivot Table query

saumyashah90 — Thu, 12 Mar 2015 07:01:48 GMT

I want to know a person moves from which page of application to which page of other application.

Previous Page Name	Page Name
a	b
c	d
d	d
c	b

Here you can see from first row that a person saw page "a" and he moved to page "b" later. and similarly others.

These all pages comes under some application.

For example 2nd row "c" comes under application "1" and 4th row "c" comes under applicaton "4".

I have mapping like

Page Name	Application Name
a	1
a	4
b	3

So I want to know

From Previous Page name -> its Application To Page Name -> its Application

Re: Pivot Table query

Gysbert_Wassenaar — Thu, 12 Mar 2015 08:24:19 GMT

For example 2nd row "c" comes under application "1" and 4th row "c" comes under applicaton "4".

Why? Where's the data that makes this clear?

Re: Pivot Table query

saumyashah90 — Thu, 12 Mar 2015 13:17:18 GMT

Re: Pivot Table query

Gysbert_Wassenaar — Thu, 12 Mar 2015 13:30:51 GMT

How can a Page Name map to two applications?

Re: Pivot Table query

avinashelite — Thu, 12 Mar 2015 13:57:52 GMT

Hi Saumya,

I think you have missed to mention the key parameters here!! in order to identify the application-page which it belongs to we need to have application id along with it....Please share few more details about your application

Re: Pivot Table query

saumyashah90 — Thu, 12 Mar 2015 14:31:31 GMT

there is one id linked with it...unique id...you can take RowNo as of now