# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Creator II

## Count by Age

 0-2 3162 3-5 1748 6-10 1295 11-14 501 15+ 962

this is what i am trying to do.

if aging >=0 and aging <= 2 then count ( distinct ReportID)

if aging >=3 and aging <= 5 then count ( distinct ReportID)

two questions: what object should I use and how is the best way to do this?

Thanks

B

Labels (1)
• ### logic

1 Solution

Accepted Solutions
MVP

I would probably go for a bar chart to visualise this. If you are to solve this issue front end only, then you will need to do nested if statement to solve this.

If( aging>=15, '15+',

If( aging<15, '11-14',

If( aging<11, '6-10', '<5') ) )

If you are allowed to work with the script then I would recommend you to look into intervalmatch to solve it .

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
3 Replies
MVP

I would probably go for a bar chart to visualise this. If you are to solve this issue front end only, then you will need to do nested if statement to solve this.

If( aging>=15, '15+',

If( aging<15, '11-14',

If( aging<11, '6-10', '<5') ) )

If you are allowed to work with the script then I would recommend you to look into intervalmatch to solve it .

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Creator II
Author

where do I place the Distinct Count ReportID

Creator II
Author

Got it thanks!!

I used a table.  It is what they wanted.

For values:

If(AGING>=15, count(distinct REPORTID),

If(AGING<15, count(distinct REPORTID),

If(AGING<11, '6-10', count(distinct REPORTID)) ) )

For Labels:

=If(AGING>=15, '15+',

If(AGING<15, '11-14',

If(AGING<11, '6-10', '<5') ) )

Tags
Community Browser