Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tesst

Hi all,

9 Replies
Anonymous
Not applicable
Author

any suggestions

prma7799
Master III
Master III

Anonymous
Not applicable
Author

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

Could you please suggest how to do from script side

balar025
Creator III
Creator III

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
Not applicable
Author

Ravi thanks for sharing this info

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

Anonymous
Not applicable
Author

any suggestions pls

Anonymous
Not applicable
Author

suggestions please

antoniotiman
Master III
Master III

Hi John,

see Attachment.

I have used AsOf Table Method.

You see changes in Script Main section.

Regards,

Antonio