Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Need Above and Below Expression Help

Hi Team,

I have Yearwise and Monthwise DOJ and DOL Data.

I know my current month Head Count for the Org. On the behalf of that Head Count I want an expression like :

July 2021 till Date Head Count is 2000 That is Ok. Now for June Month = July Month HC + July Month DOL - July Month DOJ

Now for May Month = June Month HC + June Month DOL - June Month DOJ

Now for Month April  = May Month HC + May Month DOL - May Month DOJ

Now For After July means August Month = July Month HC + July Month DOJ - July Month DOL

For September = August Month HC + August Month DOJ - August Month DOL

For October = September Month HC + September Month DOJ - September Month DOL

Till Below  and Above , I need an expression.

Please find the xls for Data and Calculation.

Thanks.

Labels (3)
0 Replies