Discussion Board for collaboration on QlikView Scripting.
I have two tables
Model ( Few Models )
When I Left Join Table A with B for some Model which are not in table B Cost isnull. And when I use Pivot table to calculate count(Model)*Costand try to get subtotals I get 0.
Table A Tableb
Country Model Model Cost
A a 10
b e 14
ABC e f 12
Can you please help me to get proper subtotals.
Use RangeSum(count(Model) * Cost)
Hope it helps
use the following expression.
This will consider the null values as 0.
Thanks Nilesh, I have already tried this but not getting the desired result.
Please find the result which I get in the Pivot table.
For some country I get the subtotal which is random and for tother even the subtotal is missing.
count(Model) * if(Cost=' ',0,Cost)
Can you attach the sample app?
Thanks. Its giving me correct total but the partial subtotals are still 0.00 and for some its random number.
sum( alt( cost, 0 ) )
Doesnt help much.
use aggr function by declaring the field u want the aggregation for.... tht will solve the problem