# Qlik Sense App Development

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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.

Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Help needed with calculated dimensions

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

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

Dual('>3',3)))

2 Replies
Highlighted
MVP

## Re: Help needed with calculated dimensions

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

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

Dual('>3',3)))

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.