Discussion Board for collaboration related to QlikView App Development.
I have attached my qvw file in my second expression (sellout %) in bottom total it is showing this sum of percentage value
But it has show like this in sub total. please help us how to fix it something like 8625/14062, 5438/14062
Try this expression:
Sum(Sell_NDPCurrMth)/Sum(TOTAL <[Product Line]> Sell_NDPCurrMth)
May be as below for sellout% expression:
There is any other way get it by using column "Sell_NDPCurrMthPercent". I have to use only this column for calculate % not Sell_NDPCurrMth. Just mentioned the sample to data. that % column calcaulted in DB on many business logic
I hope this may helps you.
This is the best you can do:
If(Dimensionality() = 0, Sum(Sell_NDPCurrMth)/Sum(TOTAL <[Product Line]> Sell_NDPCurrMth),