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

plz find my attachment

qliksus
Specialist II
Specialist II

May be something like this

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

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

sunny_talwar

Not sure why, but recreating the chart works for some reason. Used the same exact expression

Capture.PNG

kunkumnaveen
Specialist
Specialist
Author

so you mean i should delete this chart and create a new one

sunny_talwar

Yup, that's exactly what I mean

veidlburkhard
Creator III
Creator III

Hi naveen,

when I opened your app, I saw you marked the 'Relative' check box with your expression which is already 'relative'.

See the picture:

TEST.jpg

Hope this helps

Burkhard

sunny_talwar

Good catch, did not notice that

kunkumnaveen
Specialist
Specialist
Author

i dont known what magic have u got with you ,but its not working for me,i had recreated the chart

    dimension: name1,decision

expression:

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

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

and i getting thisscreen1.png



sunny_talwar

Look at Burkhard Veidl‌ response below

kunkumnaveen
Specialist
Specialist
Author

%3.png