Selective Selection on Pivot Table .

[#1]

I have been working with Qlikview for last 1 month. I am working in a 64 bit Environment with Windows 2003 EP Edition , with 32 GB of RAM. We have 1 Billion records. that i am working with.

The requiremnt is a Pivot Table.

I was able to develop the Pivot Table. But i am stuck in one selection.

I am uploading the QVW file , which will give you the idea of the Problem.

If i want to see al the Values of the Parameters where X=12

Then it deselects other Parameters like L,M,N,Y . As i have selected 12 , which inturn selects X.

I did try to use the Loosen Table functionality. But i was unsussful.

Can some body give me an idea , how to tackle this kind of Problem.

[#2]

Hi

I think a table box (in stead of a pivot table) will do the what you are after. See attached for amends to your file that shows what I mean.

Regards,

[#3]

I would need a pivot table only as , if we select the event = 2 the we get diffrent set of coulmns. ( A,B,C) and if we select event-=1 then we get columns like L,M,N,X,Y

I requiremnet is that if we select Event=1 , the we get the Pivoted columns like L,M,N,X,Y .

But if we further select Evalue as 12 then i see only one column that is X.

But i wanted to see all the columns from L,M,N,X,Y where X=12.

[#4]

I wanted to perform a selection after the Pivot table is generated , as i can use the filter on the newly generated columns.

[#5]

I've created an extra table of EP_ID and a merge of parameter and value. Using this merged field as select box van possibly solve your problem. Give it a try.

[#6]

Hi Mark ,

Thanks for the Solution . Sorry for not able to give you a better example.

Actually the field that is being displayed in the Pivot table is not exactly Value , but a nested if block on Evalue / Value based on the Event & parameter Column.

But another hitch is :

My table record is 740 MM , so when i try to do another Load , it load again 740 MM times.

"LOAD EP_ID, Parameter&' '&Value AS Selection RESIDENT Event;"

[#7]

This Load Again Takes a lot of time : Do you have any suugestions to over come this.

[#8]

Hi Mark ,

The below expression,

LOAD EP_ID, Parameter&' '&Value AS Selection RESIDENT Event

works well for small number of data . But the no of records in my case is 740 MM .

When i try to use it , it fails afetr 490 MM records. (taking 6 Hrs).

Its gives the Error , Fails to load the Application.

I tried to relod the application 3 time , but every time after 400 MM to 500MM record processing it fails to Concatenate further rows.

Regards

Debashish.

[#9]

Maybe a simple macro can be a solution for your problem, I added a button to your QlikView document to give you an example. Good luck!

Mark

[#10 · Accepted solution]

Mark Thanks , this Macro really solved the Problem. I do not have to go throgh the costly concatenation operation.

But i also have a small query , can i somehow do an And Operation on my selection

Like X=12 and Y<4 ,

Can multiple And condition be possible in Main Page.

Regards

Debashish.