If you really want to cripple your data model you can use Generic load. See the help file for details.
LOAD *, 1 as Counter INLINE [
Otherwise leave the data as it is and use a pivot table to show the data as a crosstable.
XD to cripple it^^
I suspected that answear;)
Thank u anyway:)
But i have to define every date?
There's no possibility to cripple it automatically, mean any QV function?
And yes, if i can i try to avoid using this. But i have some "self animated" charts using crosstables and i dont want to create them with Excel any longer:/
This will only be used for some special chart, where i didn't find a solution to avoid using crosstables.
The inline is just an example, you can use a resident load instead. See attached example. It has a pivot table based on the original data format and two straight tables using the exploded data from the Generic load. My advise is to not do a generic load and use the pivot table instead to show the data in that layout.
comm85348.qvw 151.2 K