Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
Would really appreciate your help on my below concern
To explain more on that
i have server models a,b,c,d ... as my dimentions and i have Memory , processors , harddrives , controllers on the columns which are calculated columns ...
now i need to have Memory , Processor harddrives as seperate objects outside the table so that i can select which ever i want only to be shown
can you help here please ??
Below mentioned snapshot is what i get when i click on reply
I dont get to see any attach / advanced filter option ..;. how do i go about getting it ??
Dear Ravi,
I think you have to show only those calculated dimension which are selected in list box. so as per my understanding solution will be
2. Now Enable condition for the calculated dimensions.
for example we want report as per Memory and Controllers
Condition for Calculated Dimension Memory will be:
if(GetSelectedCount(Dimension)>0 and wildmatch(Concat(DISTINCT Dimension,','),'Memory'),1,0)
Condition for Calculated Dimension Controllerswill be:
if(GetSelectedCount(Dimension)>0 and wildmatch(Concat(DISTINCT Dimension,','),'Controllers'),1,0)
Create condition for your all dimensions.
and Include inline field Dimension in list box and enable check box in for multiple selection
I hope it will be help you.
Regards
Kiran Rode
+91 8976977897
Please Save this dialog with some text and try to edit,you may see the use advanded editor or attach link then
dfgsDFsdfDFSDFDfsdfasdf
Oops , m sorry , it was a typo
in your inbox click see following image and click on that in your inbox then you can attch qvw files
Hi ,
Finally could attach the QVW.
Could you please help in getting conditional hide /show columns which has expressions based on the selection
Hi ,
I have attached the QVW now.
Can you please look through this and help me out
What do you want to have in your Memory list box? Numbers like below?
Further, your data model seems incomplete. Should there not be a link between Basctry and AttachWW?
HIC
Hi Henric ,
Memory is a calculated column like below
=if(V_Attach=0,(Sum([Units Memory_Attach]))/(Sum([Units Server_only_Attach])),(Sum([NetRev Memory_Attach]))/(Sum([NetRev Server_only_Attach])))
where V_Attach is a variable used like a toggle switch , when U:U is selected in my qvw , it should perform first half of the calculation else when $:$ is selected the second half calculation should be displayed
the data model is like that , BASCTRY and ATTACH are two different things and hence no relation