Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i having a strange requirement and a challenging one
where as i am having a data of
sample data as below any help is would be appreciated
Emp name | product | avg market value per product in days | avg over all engineers data with product | here % were calculated by col(2) by col(1) | ||
---|---|---|---|---|---|---|
venkat | wipro | 7.5 | 2.5 | 2.5/7.5 = some value in | ||
sunil | airtel | 8.5 | 5 | |||
arun | idea | 6 | 9.5 | |||
satish | airtel | 8.5 | 8 | |||
rani | wipro | 7.5 | 10 |
my problem is here i am freezing the values by using sum(total<Product Team>{<empname=, Product= > closures) and same for the product
where has when i make a selections on empName =Rani or any at the the bottom only her values should be visible
but here i am getting the data this way
Emp name | product | avg market value per product in days | avg over all engineers data with product | here % were calculated by col(2) by col(1) | ||
---|---|---|---|---|---|---|
venkat | wipro | -- | -- | - | ||
sunil | airtel | - | - | |||
arun | idea | - | - | - | ||
satish | airtel | --- | - | - | ||
rani | wipro | 7.5 | 10 | 7.5/10 = 1.33 |
ok that's my problem where has its should be only visible or it should be populate to the top as we see in the list box
here in sample data i have only 4 rows but in my app around thousand of record were there i cant scroll down to see where this values were there
Help: it should behave a like list box selections for example what ever value i select it should populate at top or
should come like a normal straight table Resource Library
gwassenaarsana.ismailswuehljaganQlikViewLayout & VisualizationsApp DevelopmentSETANALYSIS on formula based on variable
Hi! Under chart properties>presentation tab> is suppress zero values checked?
Also in expression if you want to be able to make selections in empname field why is it being ignored?:
sum(total<Product Team>{<empname=, Product= > closures)
Please could you provide an example file?