Count Remaining Period in a Quarter

[syedsaqib]

Hello Everyone,

Can someone please help me with Formula to calculate remaining period in each quarter in Qliksense.

For Example, If Current Period selection is 7 , which means I am in Quarter 3 and I should get remaining period = 2 (because period 8 and period 9 is to go in this quarter).

I have provided example for Quarter 1 and Quarter 3 in below screenshot.

Thanks! 

[Vegar]

What if you try something like this? 

Max({<Period, [Qtr no] = {$(=max([Qtr no])} >} Period) - max([Qtr no]) 

[Taoufiq_Zarra]

@syedsaqib  other option :

=count({1<[Qtr No.]=p([Qtr No.]),Period={">$(=GetFieldSelections(Period))"}>} Period)

[Vegar]

Nice one @Taoufiq_Zarra. I choose this one my previous suggestion. 

[Taoufiq_Zarra]

Thanks @Vegar  😉

[syedsaqib]

ThanksTaoufiq ,

It's not working as shown in your screenshot. 

Could you please explain this part of your formula?  1<[Qtr No.]=p([Qtr No.])

Regards,

Syed

[Vegar]

1 tells the expression to consider the whole set, not only your selected set. 

[Qtr No.]=p([Qtr No.] tells the expression to reduce your set to only consider the Qtr No. that are available in your current selection. An alternative to this modifier to ensure only one Qtr No. could be to use [Qtr No.]= {"$(=max([Qtr No.])" ) 

[Taoufiq_Zarra · Accepted solution]

@syedsaqib 

@Vegar  well explained, I only add qvf example in attached

[syedsaqib]

Thanks. You guys are really helpful.