Discussion board where members can get started with QlikView.
I think this is a very basic question. I have the following table in the script.
Load * Inline [
Then I want to make a new field for Year and one for Month. I did it in the script as follows:
Year(Subscription) as Year,
Month(Subscription) as Month
However I wish that Year and Month were associated with the Subscription date, which are not in my example (while a calculated dimension Year(Subscription) in a chart is associated)....
Can anyone tell me what I'm missing? Is there a nice tutorial to QV scripting available somewhere (one which is not 500 pages long...)?
Thank you very much
Go to Solution.
Year(SubscriptionDate) as Year,
Month(SubscriptionDate) as Month,
This seems to work..
However QV scripting is still misterious to me...