Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Use of Set Modifier with As Of-Table

Can one use a set modifier with the As Of-Table as follows:

Sum({$<MonthDiff={"<12"}, [Generic Drug Indicator] = {'YES'}>} Amount)

The above gives me values lower than expected.

Regards.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Many thanks Sunny, i realised that my dimension was wrong it was MonthYear instead of AsOfMonths

View solution in original post

4 Replies
sunny_talwar

Would you be able to share a sample?

Anonymous
Not applicable
Author

Many thanks Sunny, please find attached.

The chart in the second tab in container is the one which i am referring to.  The chart in the first tab of the containers has no set modifiers.

Regards.

sunny_talwar

I guess I need to ask you what is the expected value? Right now we have these, what would you want them to be?

Capture.PNG

Anonymous
Not applicable
Author

Many thanks Sunny, i realised that my dimension was wrong it was MonthYear instead of AsOfMonths