Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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