Discussion Board for collaboration related to Creating Analytics for QlikView.
no change required in expression
see below code
hope this helps
What is monthYear ? Should i make a variable called month year also???
its a field available in your application.
Hmmm - i dont see it anywhere???
IS it because i only have Personal edition ATM?
if you have date field in script then make it as
Month(Date)&'-'&Year(Date) as MonthYear
Hope this helps
I dont have any scripts - I made my DATE dimension in the data warehouse (ssis) - i have not created a MasterCalendar.... Do i need to do that?
so u have only month dimension? dont you have any dimenion related year, date, something like that...
No i have a DateDimension
My Date dimension includes: Days, Month, Years, Quarter, Weeks and so on....
I have a row called Month_Name which includes january,feburary and so on... I try to use that one but it doesnt work?
i cant it to work - i think its something about my timestamps ? Yours are in // - The strange think is when i make vCurrMonth i can see my months when selecting - but i cant see any sum...
If i make a listbox with the date as dimension and sum on my byprice it works perfectly!
Have i forgotten to change something somewhere???