Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all QV users,
I've encountered a problem in Qlikview.
I have constructed an ImR chart in Qlikview and used the following expression to calculate the average:
avg(TOTAL aggr(sum(johan),Month))
It works fine but now am I trying to do the same with a calculated dimension instead of Month, this is the dimension I have:
=date(monthstart(Notif_date),'MMM YY')
Does anyone know how I combine these to two? I want to somehow replace Month in the first expression with the calculated dimension above.
Thanks!
To make it easier, why don't you add the function "=date(monthstart(Notif_date),'MMM YY')" into your script ?
This way you'll avoid to get a calculated dimension, and your results will be faster ?
Regards,
Sébastien
Ok,
how do I add it into my script?
thanks
Hi,
In the script:
date(monthStart(Notif_date),'MMM YY') as MonthYear
Regards.
Thanks!
It solved my problem.
Regards