I want to autogenerate numbers in expression editor

[siddharthsoam]

Hi,

I have a quarters filter such that, my accounting numbers and quarters are related

Accounting Period	Quarters
1	Q1
2
3
4	Q2
5
6
7	Q3
8
9
10	Q4
11
12

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

[petter · Accepted 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.

[siddharthsoam]

Thanks Petter,

Can you please elaborate why we take 1 instead of $?

[petter]

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:

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set...