Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

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

Re: looking for change in expression

Try this expression:

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

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

47 Replies

Re: looking for change in expression

can you try this

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

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

kunkumnaveen
Contributor III

Re: looking for change in expression

No luck,its not working

screen3.png

Re: looking for change in expression

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
Contributor III

Re: looking for change in expression

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
Contributor III

Re: looking for change in expression

Any helps or suggestion to achieve this task plz

Re: looking for change in expression

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
Contributor III

Re: looking for change in expression

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

Re: looking for change in expression

Would you be able to share your application?

kunkumnaveen
Contributor III

Re: looking for change in expression

Hello plx find the attachment

Community Browser