topic Re: Calculation Condition and Detached in QlikView

Calculation Condition and Detached

Thu, 11 Dec 2014 16:22:45 GMT

Hi I have hopefully have a simple question I have a Chart with a straight table list of Projects, there is a field [Project Status] that can have a number of variables , Initialized, Approved, started and Closed.

For my chart I’m only interested where the [Project Status] = ‘Approved’.

So I thought it was a simple case of adding “if([Projects Status]= 'Approved',1,0)” to the Calculation Condition.

But this only seems to work if first filter for “Approve using a list box etc., and then changing the properties to Detached, otherwise all I get is “Calculation condition unfulfilled”

What I want is for my Chart to only show Approved Projects without setting any filters.

Re: Calculation Condition and Detached

MK_QSL — Thu, 11 Dec 2014 16:33:20 GMT

Use Calculated Dimension as below

If([Projects Status]= 'Approved',[Projects Status])

And tick suppress when value is null

Re: Calculation Condition and Detached

Thu, 11 Dec 2014 16:45:00 GMT

Thanks Manish but this just gives me every Option

Re: Calculation Condition and Detached

Thu, 11 Dec 2014 17:07:38 GMT

Did you tick the "Supress when value is null" as Manish mentioned? It should work.

If still doesn't work, you can attach the file for us to check.

Re: Calculation Condition and Detached

MK_QSL — Thu, 11 Dec 2014 17:09:38 GMT

Count({<[Project Status] = {'Approved'}>}Activity)

===========================================================

For Calculated Dimension, you have more than one dimension, so use as below

IF([Project Status] = 'Approved', Dimension1)

IF([Project Status] = 'Approved', Dimension2)

IF([Project Status] = 'Approved', Dimension3)

Where Dimension1, Dimension2 and Dimension3 are the name of your fields...

Now you can use Count(Activity) or Count(Distinct Activity)

===========================================================

Or simply use

Dimension1

Dimension2

Dimension3

and The Expression I have provided at the top

Re: Calculation Condition and Detached

Thu, 11 Dec 2014 17:42:27 GMT

Hi sorry dont understand why this should be so complicated

Have enclosed the file

Thanks

Mark

Re: Calculation Condition and Detached

Thu, 11 Dec 2014 17:45:24 GMT

Please see attached. Hope this is what you are looking for.

Re: Calculation Condition and Detached

MK_QSL — Thu, 11 Dec 2014 17:47:57 GMT

Create a Chart

Dimension

use Calculated Dimension

=IF([Projects Status] = 'Approved', [PROJECT ID])

2) use Calculated Dimension

=IF([Projects Status] = 'Approved',[Projects Status])

Tick suppress when value is null for both of the above Calculated Dimennsion

Expression

Count([Activity ACTUAL START])

Re: Calculation Condition and Detached

MK_QSL — Thu, 11 Dec 2014 17:49:04 GMT

Create a Chart

Dimension

Project ID

Project Status

Expression

Count({<[Projects Status] = {'Approved'}>}[Activity ACTUAL START])

Re: Calculation Condition and Detached

Anonymous — Thu, 11 Dec 2014 18:27:47 GMT

you don't need calculated dimension for your issue...simply use [PROJECT ID] as dimension and update your expression to the following:

Count({<[Projects Status]={'Approved'}>} [Activity ACTUAL START])

Re: Calculation Condition and Detached

Thu, 11 Dec 2014 19:54:15 GMT

Hi Mark,

please use this

=if([Projects Status]='Approved',Count([Activity ACTUAL START]))

I try the same and it is working

Re: Calculation Condition and Detached

Fri, 12 Dec 2014 07:30:55 GMT

Thanks to eveyone's answers, its now displaying the data I want.

But that still leaves one question what does Calculation Condition do as I though this would have been a typical example.

Re: Calculation Condition and Detached

MK_QSL — Fri, 12 Dec 2014 08:19:48 GMT

What jsaradhi has replied, I already replied well before (Just check the reply time of all).... I have provided two different method of getting the end result.. Looks like you ignored my answer or may be never tested...

Happy Qliking !!

Re: Calculation Condition and Detached

Anonymous — Mon, 15 Dec 2014 14:49:36 GMT

Calculation Condition in the General tab in an object properties window is to determine if the chart itself can be calculated or not. let's say you have a straight table and you do not want to calculate and display the results in that table unless the resulting rows are less than a certain number say 1000...or you want to calculate the table only when a certain selection is made, etc.