Displying Rows in Pivot table

[srinivasa1]

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

[raghavsurya]

Hi Srini,

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

Regards,

Raghav

[srinivasa1]

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

[srinivasa1]

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

[#5]

Hi srinivas,

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

[deepakk]

hi Srini,

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

[srinivasa1]

Thx venu,

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

srini

[srinivasa1]

hi Deepak,

thx now its working .