Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

how to write percentage expression

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 

pastedImage_0.png

pastedImage_1.png

pastedImage_2.png

please find my attached test file

12 Replies

Re: how to write percentage expression

Can you reattach the qvw, I am unable to open it due to error

kunkumnaveen
Contributor III

Re: how to write percentage expression

yes ,i will doing it

kunkumnaveen
Contributor III

Re: how to write percentage expression

Hello

kunkumnaveen
Contributor III

Re: how to write percentage expression

Hello sunny ,

i was trying to attach file from long time ,finally i did now

plz the attachment

Re: how to write percentage expression

I don't see the charts from the image above in your application. Which object are we working on?

kunkumnaveen
Contributor III

Re: how to write percentage expression

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

kunkumnaveen
Contributor III

Re: how to write percentage expression

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

kunkumnaveen
Contributor III

Re: how to write percentage expression

plz any more suggestion and helps to achieve this requirement plzz

MVP
MVP

Re: how to write percentage expression

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,

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser