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

[srinivasa1]

Pls help me if any knows....

[#3]

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

[srinivasa1]

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.

[deepakk]

HI Srini,

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

[srinivasa1]

Hi Deepu.

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

[srinivasa1]

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.

[deepakk]

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.

[srinivasa1]

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.

[deepakk]

Hi srini,

Please find a sample application in the attachment