topic Re: Calculation mismatch in QlikView

Calculation mismatch

Fri, 20 Feb 2015 17:14:01 GMT

Hi,

I have 2 charts. I have written the same expression on both the charts for (FTE allocated - green). however, once i select any division, the number of FTE allocated on both the chart differs. Ideally FTE allocated should be a straight line (in chart1) and should be equal to the FTE allocated shown in chart 2.......for eg:with current selection, in chart1 i should have 2.13 as a stright line for FTE allocated.

Any help on this would be appreciated.

Re: Calculation mismatch

Gysbert_Wassenaar — Fri, 20 Feb 2015 17:49:33 GMT

Try this:

=if(getselectedcount(Division)=1,Sum(Total [Time to complete])/Sum({<Division=>}Total [Time to complete])*Sum(Resource),sum(Resource))

Re: Calculation mismatch

Fri, 20 Feb 2015 17:57:22 GMT

can you please guide me more here..seems i m lost...

Re: Calculation mismatch

Gysbert_Wassenaar — Fri, 20 Feb 2015 18:02:10 GMT

See attached example.

Re: Calculation mismatch

Fri, 20 Feb 2015 18:15:33 GMT

thanks a ton

Re: Calculation mismatch

Sat, 21 Feb 2015 08:03:32 GMT

the only error that i can see now is that these 2 charts are woeking perfectly with alul listboxes but it gives an incorrect output only when i select an option from industry and dont selecet any field from the other listboxes,

if i select one more value from another listbox, output comes correct. so the problem is only selecting an option from industry on standalone basis.

attached for your refrence.

can you please help.