topic Re: Count Remaining Period in a Quarter in App Development

Count Remaining Period in a Quarter

syedsaqib — Sat, 16 Nov 2024 02:09:22 GMT

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!

Re: Count Remaining Period in a Quarter

Vegar — Fri, 12 Jun 2020 22:19:38 GMT

What if you try something like this?

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

Re: Count Remaining Period in a Quarter

Taoufiq_Zarra — Fri, 12 Jun 2020 22:33:11 GMT

@syedsaqib other option :

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

Re: Count Remaining Period in a Quarter

Vegar — Fri, 12 Jun 2020 22:37:05 GMT

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

Re: Count Remaining Period in a Quarter

Taoufiq_Zarra — Fri, 12 Jun 2020 22:39:55 GMT

Thanks @Vegar 😉

Re: Count Remaining Period in a Quarter

syedsaqib — Sat, 13 Jun 2020 03:18:01 GMT

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

Re: Count Remaining Period in a Quarter

Vegar — Sat, 13 Jun 2020 05:38:18 GMT

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.])" )

Re: Count Remaining Period in a Quarter

Taoufiq_Zarra — Sat, 13 Jun 2020 09:09:17 GMT

@syedsaqib

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

Re: Count Remaining Period in a Quarter

syedsaqib — Wed, 17 Jun 2020 21:09:26 GMT

Thanks. You guys are really helpful.