Discussion Board for collaboration related to QlikView App Development.
all i am having trouble to display the same totals, while selecting the dimensions . my calculation is a combination of
gross amount - if flag = yes qty * asp , gross amount / gross amount and i have tried sum(aggr(.... dim1) dim1 meaning the calculation
which should not change, i have tried total function total<dimesion1 > . even i tried in the set analysis sum( dimension1 =, amt) nothing
worked . is there any solution for this . attached is the copy , the dimension is quarter which is the selector , the column to see is Rate
that is the one keeps on changing while selecting the SELECTOR quarter ,
Thanks in advance . !
nope only the totals , if u change the cyclic group to period , you can see the exact problem . meaning when you the select the quarter from selector the rate value calculates automatically which it should not
stalwar1 see when selecting the selector quarter the rate changes which it should not. on the other hand it should also perform its(rate) calculations when selecting other dimensions in the cyclic group, but for period the total and individual row values should be same . because that rate is driving other calculations .
please let me know if you need information . thanks for help ..
it works exactly what i wanted, but the thing is that i have just scrambled data here in the attachment , when i take the exact formula and replace in my original qvw it doesn't work ..