Discussion Board for collaboration on QlikView Layout & Visualizations.
We have yearly data but on chart(on x axis) we have to show MAR-Yearname (Mar1990,Mar1991) but data should be yearly.
Can you please suggest on this
If you have Date Field in your Script, create MonthYear as below
Date(MonthStart(Date),'MMMYYYY') as MonthYear...
Now use below as calculated dimension in your chart
You do not have a Year colomn in your script? because that would be the easiest.
I suggest editing your script and add a Year Column.
It is not working.
After modifying script suggested by you I am able to see data only for march for all years.
When i click on other month it is showing blank.
Provide sample application...
After modifing script as suggested by Mr. Manish.
Just add MonthYear as your Dimension.
change expression like below