topic Re: looking for change in expression in QlikView

looking for change in expression

kunkumnaveen — Tue, 12 Apr 2016 06:51:28 GMT

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 values

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

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

Re: looking for change in expression

Kushal_Chawda — Tue, 12 Apr 2016 06:56:31 GMT

can you try this

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

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

Re: looking for change in expression

kunkumnaveen — Tue, 12 Apr 2016 07:03:53 GMT

No luck,its not working

Re: looking for change in expression

Kushal_Chawda — Tue, 12 Apr 2016 07:05:53 GMT

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)

Re: looking for change in expression

kunkumnaveen — Tue, 12 Apr 2016 07:09:01 GMT

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)

Re: looking for change in expression

kunkumnaveen — Tue, 12 Apr 2016 07:24:39 GMT

Any helps or suggestion to achieve this task plz

Re: looking for change in expression

Kushal_Chawda — Tue, 12 Apr 2016 07:27:53 GMT

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)

Re: looking for change in expression

kunkumnaveen — Tue, 12 Apr 2016 07:33:51 GMT

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

sunny_talwar — Tue, 12 Apr 2016 07:40:43 GMT

Would you be able to share your application?

Re: looking for change in expression

kunkumnaveen — Tue, 12 Apr 2016 07:42:45 GMT

Hello plx find the attachment

Re: looking for change in expression

kunkumnaveen — Tue, 12 Apr 2016 07:43:07 GMT

plz find my attachment

Re: looking for change in expression

qliksus — Tue, 12 Apr 2016 07:45:20 GMT

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))

Re: looking for change in expression

sunny_talwar — Tue, 12 Apr 2016 07:51:10 GMT

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

Re: looking for change in expression

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

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

Re: looking for change in expression

sunny_talwar — Tue, 12 Apr 2016 08:06:38 GMT

Yup, that's exactly what I mean

Re: looking for change in expression

veidlburkhard — Tue, 12 Apr 2016 08:12:41 GMT

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:

Hope this helps

Burkhard

Re: looking for change in expression

sunny_talwar — Tue, 12 Apr 2016 08:14:34 GMT

Good catch, did not notice that

Re: looking for change in expression

kunkumnaveen — Tue, 12 Apr 2016 08:14:34 GMT

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 this

Re: looking for change in expression

sunny_talwar — Tue, 12 Apr 2016 08:15:36 GMT

Look at Burkhard Veidl‌ response below

Re: looking for change in expression

kunkumnaveen — Tue, 12 Apr 2016 08:22:56 GMT