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


1 Solution

Accepted Solutions
sunny_talwar

Try this expression:

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

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

View solution in original post

47 Replies
Kushal_Chawda

can you try this

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

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

kunkumnaveen
Specialist
Specialist
Author

No luck,its not working

screen3.png

Kushal_Chawda

try to add decision as well in expression


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

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

kunkumnaveen
Specialist
Specialist
Author

i did add Decision ,but it says NO DATA TO DISPLAY

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

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

kunkumnaveen
Specialist
Specialist
Author

Any helps or suggestion to achieve this task plz

Kushal_Chawda

can try this or post the sample application so you will get the quicker answer


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

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

kunkumnaveen
Specialist
Specialist
Author

yes i will try  to post my sample application,but it is about 13mb  so plz gives me few time to upload it

sunny_talwar

Would you be able to share your application?

kunkumnaveen
Specialist
Specialist
Author

Hello plx find the attachment