Issue in calculate average of month for semi addtive measure

[Anonymous]

Hello Expert,

I have measure stock which I want to do sum for all other dimension except date.

for date I want average.

So I write expression sum(stock)/(maxdate-mindate).

This is working if I know date range

Now i want to show monthly trend for stock.So how can I get each month start date and end date in expression.

I wan on the fly strt date and end date depends on my dimension month.

Thanks ,

Kiran

[datanibbler]

Hi,

there are functions for this in QlikView. Monthend(), Monthstart(), Addmonths().

For instance, if you write Monthstart(Today(), -1), that is the 1st of November - the start of the previous month.

Will that help you?`

Best regards,

DataNibbler