Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

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
kunkumnaveen
Specialist
Specialist
Author

yes this is my requirement i need % between same  name1 values ,same as shown in the screen short,  i was using the same expression but unfortunately it is not working for me .

   count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

/count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1>PRUEFLOS)

jonathandienst
Partner - Champion III
Partner - Champion III

Then again --> Looking at your screenshots, it looks like your expression is working.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
kunkumnaveen
Specialist
Specialist
Author

Hello ,

Any suggestion for my requirement ,i have attaches the file