This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
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 .
View solution in original post
where do I place the Distinct Count ReportID
Got it thanks!!
I used a table. It is what they wanted.
If(AGING>=15, count(distinct REPORTID),
If(AGING<15, count(distinct REPORTID),
If(AGING<11, '6-10', count(distinct REPORTID)) ) )
If(AGING<11, '6-10', '<5') ) )