Discussion board where members can get started with Qlik Sense.
I have a quarters filter such that, my accounting numbers and quarters are related
I have a single selection in quarters filter,
if I select Q2 I am getting
Accounting Period-4,5,6 in KPI
Required Output should be -1,2,3,4,5,6 in KPI i.e. it should generate a series starting from 1
Go to Solution.
I can't see any accounting periods in your KPI - there are however month names there.... so I guess that is what you are thinking about then?
If so - you could change the $ into a 1 in your set expression modifier.
Can you please elaborate why we take 1 instead of $?
These are both set expression identifiers. So $ means the current selections whereas 1 means all data ignoring any selections.
You can find more info and explanations here: