Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

looking for change in expression

Hello

my requiremnt is to show % of each decision filed value of same supplier ,to achieve this in a bar chart

  i took dimension: 1)name1        //(supplier name filed)

                            2)decision    //(accepted,rejected,exception)

and expression i wrote is:

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

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



so problem is  while i am showing all the supplier i am getting different valuesscreen1.png

but if i choose one supplier then i am able to get  what i am looking


screen2.png

this is what i am looking ,so i think i need to do a changes in my expression ,any one suggest me what changes should i need to do plz


47 Replies
kunkumnaveen
Specialist
Specialist
Author

i am getting these values when i unchecked relative option

%3.png

%2.png

sunny_talwar

Go to numbers tab and select Fixed to 2 and Show as percent

Capture.PNG

kunkumnaveen
Specialist
Specialist
Author

HI

%2.pngi am getting ,these values when i unchecked relative option

%3.png

kunkumnaveen
Specialist
Specialist
Author

WORKING, but a small problem is if i select a value from decision filed it should show its respective % only ,but now it showing me 100%,what i mean is

suppose  JAY GANESH CHEMICAL:  accepted :94.12%

                                                            rejected :2.94%

                                                            exception  :2.94%

i am getting these values when i choose only name1,material name fields ,but if i chose decision filed then  i am getting these

%4.png

kunkumnaveen
Specialist
Specialist
Author

i think there should be a small change in the expression,so that on clicking decision filed it should show its respective % only, am i right

qliksus
Specialist II
Specialist II

its showing the right values simply select the show in percent option in number tab it will work

veidlburkhard
Creator III
Creator III

Hi naveen,

look at the 'Number' tab and mark the check boxes same as in the picture below

TEST.jpg

kunkumnaveen
Specialist
Specialist
Author

HI,

WORKING, but a small problem is if i select a value from decision filed it should show its respective % only ,but now it showing me 100%,what i mean is

suppose  JAY GANESH CHEMICAL:  accepted :94.12%

                                                            rejected :2.94%

                                                            exception  :2.94%

i am getting these values when i choose only name1,material name fields ,but if i chose decision filed then  i am getting these

%4.png

i think there should be a small change in the expression,so that on clicking decision filed it should show its respective % only, am i right

sunny_talwar

What is your current expression? Can you copy paste it from your application? The reason I ask this is because, I don't see the same issue when I click into a particular supplier

kunkumnaveen
Specialist
Specialist
Author

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

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