Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

New Contributor II

Subtracting one of the Quarter among multiples selected Quarter in Qliksense


I applied a logic in which if I select multiple Quarter from Quarter filter i.e. say Q1 & Q2 of year 2017 then it should return the value

Q4 of 2016 year and Q1 of 2017(by subtracting one in previous category).

By using Quarters={$(=Concat(Distinct 'Q' & (( mid(Quarters,2))-1),','))},

it is giving subtract by one of selected Quarter.

This works perfectly in case of one Year i.e. 2017 i.e. if I select Q2 , Q3 it is giving Q1 and Q2 respectively which is correct.

But it fails in computing previous of Q1 which should be Q4 of Previous Year.

Kindly help.

Community Browser