How to use set analyst in dimensions?

[panwipa2528]

as data in attach file How to use set analyst in dimensions?
I have sheet "Data" and need result as sheet "Result"

[kaushiknsolanki]

Hi,

Do you want to do this in frontend or script will also do?

Regards,

Kaushik Solanki

[ali_hijazi]

Hello Panwipa

check attached qvw

I added 3 additional fields to the read data from excel :

Key : unique value

Now: today's quarter

Previous Quarter: the quarter just before today's quarter

and I used them in set analysis

hope this helps

[tresesco]

One front-end solution could be using firstsortedvalue() like:

[panwipa2528]

if I select quarter from time series The result can not display.

How can I do?

[sunny_talwar · Accepted solution]

Change the second expression to this in tresesco‌'s solution

FirstSortedValue({<Quarter = {"$(='<=' & Max(Quarter))"}>}Tier, -Quarter ,2)