This is my script
LOAD [Form Factor_Attach],
There is only one table used and the fields are as mentioned above . is this information sufficient ?
It is still unclear. Example: You say you want "Memory" in a separate list box. But in your Load statement, you have both [NetRev Memory_Attach] and [Units Memory_Attach] as fields. Do you want to merge these? If you do, then you should most likely load your data in a different way.
So, please post a qvw file.
I think you have to show only those calculated dimension which are selected in list box. so as per my understanding solution will be
- Create Inline table which wont linked to your data model.
- it will include 4 records as your dimension. Memory , processors , harddrives , controllers. Give field name as per your requirement. for ex. Dimension will be your field name. and it will include 4 records.
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.
Finally could attach the QVW.
Could you please help in getting conditional hide /show columns which has expressions based on the selection
EG_BC_ATT.qvw 712.8 K
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
You can always create a calculated dimension through
if(V_Attach=0,(Sum([Units Memory_Attach]))/(Sum([Units Server_only_Attach])),(Sum([NetRev Memory_Attach]))/(Sum([NetRev Server_only_Attach]))),
You can find "<Expression>" at the bottom of the field list in the List Box properties.
i created a list box and added the expression provided by Henric which is
=Aggr(if(V_Attach=0,(Sum([Units Memory_Attach]))/(Sum([Units Server_only_Attach])),(Sum([NetRev Memory_Attach]))/(Sum([NetRev Server_only_Attach]))),'Server Model_Attach')
and the list box returned just nothing and if i try changing it in the Pivot table it just returns - and no values
i want to have the columns in the pivot table to be appearing in the list box which will help me to select multiple metrics and which ever metrics are selected only values for those metrics should be displayed
i am unable to achieve this with the above procedure