Discussion board where members can get started with QlikView.
i have a pivot table calculation on counting invoices by month
and the expression is
Expr : Count(DISTINCT if(ORDTYPE='SL', if(IsNull(IVNO),'', IVNO)))/sum(SRDAYS)
my table looks like before.jpeg
i want the sum off all rows as total. so i have used like
Count(DISTINCT if(ORDTYPE='SL', if(IsNull(IVNO),'', IVNO)))/sum(SRDAYS)
then i m not getting values for all branch in all months.
the table looks like after.jpeg.
how can i sort out the issue.
CalendarMonth //YourPivoted Dimension
If this doesn't work, then try this:
View solution in original post
Add your CalendarMon.... dimension to the aggr too.