Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

I want to autogenerate numbers in expression editor

Hi,

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

  

Accounting PeriodQuarters
1Q1
2
3
4Q2
5
6
7Q3
8
9
10Q4
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

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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.

View solution in original post

3 Replies
petter
Partner - Champion III
Partner - Champion III

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
Partner - Creator II
Partner - Creator II
Author

Thanks Petter,

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

petter
Partner - Champion III
Partner - Champion III

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...