Discussion Board for collaboration related to QlikView App Development.
Hi - i'm using a crosstable as below.
The first query returns the right amount of rows (rows * columns)
The second query returns less than what i expect, when i round my volumes - the end result looks fine, I'm curious what QV is doing to not return as many rows as I'd expect.
CrossTable(WEEK, VOLUME, 6)
round (,0.001) as 1,
round (,0.001) as 2,
round (,0.001) as 3,
round (,0.001) as 4
Not sure why but I do know that Weeks field needs to be converted into numerical values first. Crosstables do something that leaves them in a String state. Use an expression like this to convert them;
You can insert the Round outside of num# which converts into a numerical value.
Date(Num#(Weeks),'DD-MMM-YY') as Weeks
I'm sure someone has a better explanation but I know this works for me. I struggled with this issue as well.
Is this a two different tables with similar columns?
Hi Tom, no, its the same table.
ok, Create a table for crosstab,and then using resident put the condition (in this case round).
Hi - this works, both methods end with the same final number of rows, so at least I can be confident the end result is correct.
Still it would be interesting to understand what QV is doing to give the difference.
Will you be able share the data file and the qlikview for a better analysis?