Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharthsoam
Contributor

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

Re: I want to autogenerate numbers in expression editor

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.

3 Replies
MVP
MVP

Re: I want to autogenerate numbers in expression editor

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
Contributor

Re: I want to autogenerate numbers in expression editor

Thanks Petter,

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

MVP
MVP

Re: I want to autogenerate numbers in expression editor

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

Community Browser