topic Re: how to write percentage expression in QlikView

how to write percentage expression

kunkumnaveen — Mon, 11 Apr 2016 10:14:05 GMT

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

Re: how to write percentage expression

sunny_talwar — Mon, 11 Apr 2016 10:16:39 GMT

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

Re: how to write percentage expression

kunkumnaveen — Mon, 11 Apr 2016 10:23:29 GMT

yes ,i will doing it

Re: how to write percentage expression

kunkumnaveen — Mon, 11 Apr 2016 11:18:56 GMT

Hello

Re: how to write percentage expression

kunkumnaveen — Mon, 11 Apr 2016 11:20:46 GMT

Hello sunny ,

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

plz the attachment

Re: how to write percentage expression

sunny_talwar — Mon, 11 Apr 2016 11:24:47 GMT

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

Re: how to write percentage expression

kunkumnaveen — Mon, 11 Apr 2016 11:32:05 GMT

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

Re: how to write percentage expression

kunkumnaveen — Mon, 11 Apr 2016 11:36:07 GMT

i have couple of levels of drill downs i need to write the expression at level3

what i mean is

so my requirement is to show percentage along with values in that supplier chart

hope u understand the requirement

Re: how to write percentage expression

kunkumnaveen — Tue, 12 Apr 2016 04:44:26 GMT

plz any more suggestion and helps to achieve this requirement plzz

Re: how to write percentage expression

jonathandienst — Tue, 12 Apr 2016 05:01:51 GMT

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,

Re: how to write percentage expression

kunkumnaveen — Tue, 12 Apr 2016 05:13:38 GMT

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)

Re: how to write percentage expression

jonathandienst — Tue, 12 Apr 2016 05:19:35 GMT

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

Re: how to write percentage expression

kunkumnaveen — Tue, 12 Apr 2016 08:13:33 GMT

Hello ,

Any suggestion for my requirement ,i have attaches the file