Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Get Quarter in a measure from month selection

Hi ,

I have my data coming in at month(Ex:Apr-15) and i have a date table with month,quarter and year.I am trying to get a measure at quarter level but it has to be dynamic based on a month selected by the end user.For example user would select Apr-15 and the measure should calculate the amount of Q2-15.

My measure for month is Sum({<scenario ={'ACTBUD'})>} amount),simple as month is a selected value,how do i get the quarter value based on the month selection.

Thanks.

1 Solution

Accepted Solutions
MVP
MVP

Re: Get Quarter in a measure from month selection

May be this"

Sum({scenario = {'ACTBUD'}, Quarter = p(Quarter), Month = >} amount)

Where

Quarter = p(Quarter) will include the whole quarter and

Month =  will ignore any selection in Month field

3 Replies
MVP
MVP

Re: Get Quarter in a measure from month selection

May be this"

Sum({scenario = {'ACTBUD'}, Quarter = p(Quarter), Month = >} amount)

Where

Quarter = p(Quarter) will include the whole quarter and

Month =  will ignore any selection in Month field

Not applicable

Re: Get Quarter in a measure from month selection

Thanks Sunny

MVP
MVP

Re: Get Quarter in a measure from month selection

No problem Sujan

Community Browser