Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Boryana
Contributor
Contributor

Alternate states in a table

Hi, 

I am trying to achieve the following output: 

Boryana_0-1655102545772.png

There are 14 accounting periods, therefore the formula about End YTD looks like this: Sum({$<[Accounting Period (F)]={"<$(=Floor($(vYTD_YearMonth),100))"}>+<[Accounting Period (F)]={">$(=Floor($(vYTD_YearMonth),100))<=$(vYTD_YearMonth)"}>}[Debit in EUR (F)])
-
Sum({$<[Accounting Period (F)]={"<$(=Floor($(vYTD_YearMonth),100))"}>+<[Accounting Period (F)]={">$(=Floor($(vYTD_YearMonth),100))<=$(vYTD_YearMonth)"}>} [Credit in EUR (F)])

How can I define the End YTD 1, so it could be filtered flexible as well?

Thanks in advance!

Labels (4)
0 Replies