Re: script side expression - Qlik Community

Anonymous · ‎2017-09-22

Hi all,

Anonymous · ‎2017-09-22

any suggestions

prma7799 · ‎2017-09-22

Like this?

Anonymous · ‎2017-09-22

Thanks but i need in script side - not on to chart level expression.

Could you please suggest how to do from script side

prma7799 · ‎2017-09-22

Please check this

balar025 · ‎2017-09-22

Hello John,

After creating rolling month calendar. You need to go with left join of calendar with fact table.

Next step is to go for group by with where condition RollingType = R12M.

MidFact:

Load *,KeyDate

resident FactTable;

Left join

Load

KeyDate,

AsofMonth,

RollingType

Calendar table;

FinalFact:

Load

KeyDate,

sum(Measure) as Measure12M

Resident MidFact

where RollingType = R12M

group by *;

Anonymous · ‎2017-09-22

Ravi thanks for sharing this info

- unfortunately i didnot received the result
could you please share qvw- apologies

Anonymous · ‎2017-09-22

any suggestions pls

Anonymous · ‎2017-09-22

suggestions please

antoniotiman · ‎2017-09-22

Hi John,

see Attachment.

I have used AsOf Table Method.

You see changes in Script Main section.

Regards,

Antonio

tesst