Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm building an Excel report with Qlikview/Nprinting and am using a ceiling function (Ceil([field1]/35))to separate every 35 rows of data to a new tab in the nprinting excel template. It worked out great, however for the very last tab, I need to do a sum calculation. Depending on the report run, the number of tabs can vary depending on the number of rows of data, which is why I'm using the ceiling function. Is there a way to do an if statement using max and ceiling, so that my sum calculation only returns on the very last tab?
This isn't right, but I was thinking something like, if(is max(ceiling(field1)), sum(field2))
Is there a way to build a formula similar to the above?
Thank you!
First, i'm not sure what/how you are really using this. But this would be how to do your if statement:
If( Ceil([field1]/35) = max(aggr(ceil([field1]/35),[field1])), sum(field2))