Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI, I am looking for this requirement ,
this requirement is a level 2 requirement , what i mean is after clicking on level 1 it will bring me to level2
so category and decision filed are selected at level1 based up on that selection the level 2 shows only those supplier which full fill thet category and decision values
level1 dimension:1)category
2)decision
expression
=count({$<MaterialName=,YEAR=,QUATERS=,name1=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)
level2 dimension:1)name1
2)decision
expression:1)=count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)
2) percentage expression
count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)
/count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1>PRUEFLOS)
i posted this requirement earlier , and some one had replied me with the above expression through which he is able to achieve my requirement as seen in below but when i tried using the same expression i am not getting the same out put
please find my attached test file
Can you reattach the qvw, I am unable to open it due to error
yes ,i will doing it
Hello
Hello sunny ,
i was trying to attach file from long time ,finally i did now
plz the attachment
I don't see the charts from the image above in your application. Which object are we working on?
i have couple of levels of drill downs i need to write the expression at level3
what i mean is
when u click on level1 both category and decision get selected and it will bring you to level2 where u can see list of materials and again on clicking on any material name at level2 it will bring you to supplier name
so my requirement is to show percentage along with values in that supplier chart
i have couple of levels of drill downs i need to write the expression at level3
what i mean is
when u click on level1 both category and decision get selected and it will bring you to level2 where u can see list of materials and again on clicking on any material name at level2 it will bring you to supplier name
so my requirement is to show percentage along with values in that supplier chart
hope u understand the requirement
plz any more suggestion and helps to achieve this requirement plzz
Looking at your screenshots, it looks like your expression is working. This will show % per decision for each name1 value. If that is not what you need, perhaps you could define the % you need more precisely.
This will affect the TOTAL <name1> part of the expression. Perhaps you just need to remove the <name1> fragment,