Discussion Board for collaboration on QlikView Scripting.
I have a file with revenue and the date of the first day the article was available.
My goal is to know the age of the artikels I'm doing my major revenue with.
The result should look like this:
How can I create a dimension from a datafield?
how would you do this?
Thanks for your help...
Go to Solution.
Try something like this:
In the script:
Year(ErstedDatum) as Year, // this creates a new field called Year
Now take Year as dimension member in the chart and in the expression - =Sum(EuroNet) , and check 'Relative'.
Yes, this is exactly I was looking for....