topic Re: calculated dimension in script in QlikView

calculated dimension in script

arusanah — Mon, 13 Jun 2016 19:25:32 GMT

is it possible to create calculated dimension in Load script ? here is the expression I'm trying to use but its not working

Load MonthYear,

Addmonths(MonthYear,-Getselectedcount(MonthYear)) as PreviousSelection

resident CHC

Re: calculated dimension in script

sunny_talwar — Mon, 13 Jun 2016 19:27:10 GMT

The expression you have used is not possible, but what exactly are you trying to do? May be there are alternatives

Re: calculated dimension in script

arusanah — Mon, 13 Jun 2016 19:34:07 GMT

I have to find sum sales of previous # of months.

for example if user selected Jan-Feb sum(sales) is gonna give sales for current selection.

with below expression

Addmonths(MonthYear,-Getselectedcount(MonthYear)) I can go back three months i.e( Oct-Dec) .

how do I write expression to find sale for OCT-DEC

Re: calculated dimension in script

sunny_talwar — Mon, 13 Jun 2016 19:40:29 GMT

Did you look at my response here?

Logic help

Re: calculated dimension in script

swuehl — Mon, 13 Jun 2016 19:56:28 GMT

Please try to avoid creating multiple threads coping with more or less the same topic (I've counted four).

It just makes it hard to follow a discussion and clutters the forum.

Instead, please try to give feedback to the support offered and clarify any open questions.

If you want to use the selected count in your addmonths() function, I think you would need to use something like

Addmonths(MonthYear,-$(=Getselectedcount(MonthYear)) )

or create a variable that hold the selected count and use the variable.

So, just modifying what Sunny suggested in one of the other threads:

If(Sum(Sales)/Sum({<Date = {"$(='>=' & Date(AddMonths(Min(Date), -$(=Getselectedcount(MonthYear))), 'DateFieldFormatHere') & '<=' &Date(AddMonths(Max(Date), -$(=Getselectedcount(MonthYear))), 'DateFieldFormatHere'))"}, Month, Year, Week, MonthYear>}Sales) > 1, 'Sales Increased', 'Sales Decreased')

This should be used in a front end expression, not in your load script.

If this does not work out of the box (which it probably won't), it would be most easy to help you if you create a small sample QVW and attach it to this thread.

Regards,

Stefan

Logic help

Re: calculated dimension in script

Anonymous — Tue, 14 Jun 2016 06:59:38 GMT

Hi arausanah,

You can't use GetSelectedCount on script. This may be calculated on line.

Regards