Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Pls help me if any knows....
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
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.
HI Srini,
If you want to display only one row for ApploA then which assignments should be displayed ABC or ZYZ
Hi Deepu.
thx for reply i need to disply both.but i wll not disply QMS in this case.
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.
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.
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.
Hi srini,
Please find a sample application in the attachment