Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
pkukkonen3
New Contributor II

Help needed with calculated dimensions

Hi, I got a task to create a bar chart which should show number of open cases in each cluster. The clusters are based on how long the case has been open. The clusters are open for 0 days, open max 21 days (or 3 week) and open more than 3 weeks.

At the moment my expression looks like this, but it's not for some reason display the cases which are closed "immediately"

if(STRIVE_TIME<=21,'<-3',

    If(STRIVE_TIME>21,'>3',

          If (STRIVE_TIME <= 0, 'Zero' )))

I have also tried to calculate the cluster based on difference of Registration Date and Strive Time, which is the way it "should" work.

IF (REGISTRATION_DATE  - STRIVE_TIME => 21, 'Cluster >3')

Unfortunately I can't share the application.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Help needed with calculated dimensions

=IF(STRIVE_TIME<=0,Dual('Zero',1),

IF(STRIVE_TIME<=21,Dual('<3',2),

Dual('>3',3)))

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Help needed with calculated dimensions

=IF(STRIVE_TIME<=0,Dual('Zero',1),

IF(STRIVE_TIME<=21,Dual('<3',2),

Dual('>3',3)))

View solution in original post

pkukkonen3
New Contributor II

Re: Help needed with calculated dimensions

Thank you @Manish Kacchia for the quick reply.

I started to think that maybe the issue is not after in a way I've been trying to calculate these clusters but rather in the way the open cases are being defined. My results are looking slightly different than they are looking in Cognos, in  which the dashboard I'm supposed to create with Sense was originally made. Maybe there are some additional filters used in Cognos which I'm still not aware of.