topic Displying Rows in Pivot table in QlikView

Displying Rows in Pivot table

srinivasa1 — Tue, 21 Dec 2010 08:08:54 GMT

Hi ,

How i can handle single row in QlikView Pivot table in following sinerio

Site Name Assignments

ApploA ------------ABC

ApploB-----------QMS

ApploA-----------ZYZ

in this i want show only rows for site Name ApploA bcz same Assigments reapated. more hen once

Thanks in advance.

srini

Displying Rows in Pivot table

srinivasa1 — Tue, 21 Dec 2010 08:39:08 GMT

Pls help me if any knows....

Displying Rows in Pivot table

Tue, 21 Dec 2010 09:09:43 GMT

In this case restrict your chart to display for only one location ( guessing location is the dimension )

Go to Chart Properties -> General Tab -> Calculation condition

write there getselectioncount(" Location ") = 1

this result in warning message Calculation condition Unfulfilled, if user selects more than 1 Location or no Location.

To customized the message , click on Error Messages button and select the above error message ( comes at last ) and write your message, you can do some condition checks too here.

Regards,

Shubhu

Displying Rows in Pivot table

srinivasa1 — Tue, 21 Dec 2010 09:37:03 GMT

Hi Thx for your reply. its not working. for my sinerio as i need to display by defult if site name having data in assignment columns more then once.

Displying Rows in Pivot table

deepakk — Tue, 21 Dec 2010 09:41:31 GMT

HI Srini,

If you want to display only one row for ApploA then which assignments should be displayed ABC or ZYZ

Displying Rows in Pivot table

srinivasa1 — Tue, 21 Dec 2010 09:46:27 GMT

Hi Deepu.

thx for reply i need to disply both.but i wll not disply QMS in this case.

Displying Rows in Pivot table

srinivasa1 — Tue, 21 Dec 2010 09:51:05 GMT

Hi deepak,

If ApploA Repating its ok. but i dint want to disply.ApploB bcz it has single value.i wanted to disply siteName having More then one assignments...

thx in adavance.

Displying Rows in Pivot table

deepakk — Tue, 21 Dec 2010 09:52:03 GMT

HI,

Use this expression

If(Sitename = 'ApploA' ,SiteName)

If you are using a straight table or pivot to display the report then use the code in expression expression .

In that case you can use it as set analysis

Sum ({<SiteName ={"ApploA"}>} Value)

I hope this helps.

Displying Rows in Pivot table

srinivasa1 — Tue, 21 Dec 2010 10:05:09 GMT

Thx deepk.

fro your quik Reply.

Site Name will come dynamically, and assignments also will come dynamically....

if assignments existed more then once for single site name.then i wanted disply site name in pivot tabel.

thx...onceagain.

Displying Rows in Pivot table

deepakk — Tue, 21 Dec 2010 10:50:50 GMT

Hi srini,

Please find a sample application in the attachment

Displying Rows in Pivot table

raghavsurya — Tue, 21 Dec 2010 11:54:10 GMT

Hi Srini,

You will have to drag the dimension and put it on top. Can you post your file.

Regards,

Raghav

Displying Rows in Pivot table

srinivasa1 — Tue, 21 Dec 2010 12:49:47 GMT

hi Deepak.

Thx for your help still im getting all site name when im applying in to QWF File.

site name and Assignments as Dimensions and count(MSR id) as exp.

i feel some data module pbm if possible i wll send qvw file.

thx.

srini

Displying Rows in Pivot table

srinivasa1 — Tue, 21 Dec 2010 12:51:17 GMT

thx ragh for your reply.if possible i wll send qvw file....

Displying Rows in Pivot table

Tue, 21 Dec 2010 15:40:56 GMT

Hi srinivas,

I hope, my example will give some boost to solve your problem. 🙂

Displying Rows in Pivot table

deepakk — Wed, 22 Dec 2010 04:40:33 GMT

hi Srini,

Please check the application , I have inserted a condition if(Count(..) >1 ,1)

Displying Rows in Pivot table

srinivasa1 — Wed, 22 Dec 2010 09:31:25 GMT

Thx venu,

Sorry to reply late.yest we too got soluation same way wht you done.... ..thx for help.

srini

Displying Rows in Pivot table

srinivasa1 — Wed, 22 Dec 2010 09:33:43 GMT

hi Deepak,

thx now its working .