topic Re: Calculated Dimensions in QlikView

Calculated Dimensions

danielnevitt — Fri, 15 Mar 2013 10:50:17 GMT

Hi,

I would really appreciated some help with calculated dimensions.

I have a bar graph and I would like to restrict the data to show only:

IF(MATCH(LOAD_LOC_REF,'USA','NLD','FRA'),LOAD_LOC_REF)

AND/OR

IF(MATCH(DISCH_LOC_REF,'USA',NLD','FRA'),DISCH_LOC_REF)

Both calculated dimensions work seperately, but I am unable to link them together.

Regards,

Daniel

Re: Calculated Dimensions

Fri, 15 Mar 2013 10:52:16 GMT

Upload your sample application

Re: Calculated Dimensions

alexandros17 — Fri, 15 Mar 2013 10:54:03 GMT

you have in this way a boolean answer,

try this

IF(MATCH(LOAD_LOC_REF,'USA','NLD','FRA'),LOAD_LOC_REF,

IF(MATCH(DISCH_LOC_REF,'USA',NLD','FRA'),DISCH_LOC_REF),null()

)

Hope it helps

Re: Calculated Dimensions

Gabriel — Fri, 15 Mar 2013 10:57:53 GMT

Hi,

What I would do in this situation is to try IF..Then... Else

i.e

IF x=t then ppp

Elseif y=2 Then QQQQ

End IF

I want to beleive you are scripting.......

Give this ago

Regards,

Gabriel

Re: Calculated Dimensions

danielnevitt — Fri, 15 Mar 2013 12:13:55 GMT

Hi,

I tried to follow your suggestion, but I got an error in the expression. Is there something I am missing?

Thanks for your help.

Regards,

Daniel

Re: Calculated Dimensions

jonathandienst — Fri, 15 Mar 2013 12:27:49 GMT

Since the conditions for the two are the same, I suggest that you create a combined field from these two fields for your dimension. You can stlll keep the original fields.

Combined:

LOAD Distinct LOAD_LOC_REF As COMB_LOC_REF

Resident ...;

Concatenate(Combined)

LOAD Distinct DISCH_LOC_REF As COMB_LOC_REF

Resident ....;

Without more knowledge of your data structure I cannot advise how to integrate this into your data model.

Regards

Jonathan

Re: Calculated Dimensions

danielnevitt — Fri, 15 Mar 2013 12:33:06 GMT

Hi,

Is it not possible to write OR statements as a calculated dimension?

Regards,

Daniel

Re: Calculated Dimensions

jonathandienst — Fri, 15 Mar 2013 12:37:12 GMT

Daniel

To the best of my knowledge, this is not possible. How would the expression determine which field in the OR had which value?

Regards

Jonathan

Re: Calculated Dimensions

danielnevitt — Fri, 15 Mar 2013 12:45:40 GMT

Hi,

Maybe I didn't explain it very well.

If I have the following data:

Company LOAD_LOC_REF DISCH_LOC_REF

A FRA USA

B USA GER

C NLD NLD

D ITL POL

E AUS JAP

F SWE NLD

I was trying to write a code that would show me the companies where either LOAD_LOC_REF is FRA, NLD, USA or the DISCH_LOC_REF is FRA, NLD, USA.

Therefore I would expect my bar graph to only show companies A, B, C and F.

Is that possible?

Regards,

Daniel

Re: Calculated Dimensions

alexandros17 — Fri, 15 Mar 2013 13:29:40 GMT

I'm sorry ... cut and paste

IF(MATCH(LOAD_LOC_REF,'USA','NLD','FRA'),LOAD_LOC_REF,

IF(MATCH(DISCH_LOC_REF,'USA',NLD','FRA'),DISCH_LOC_REF,null())

)

it must work!!!

Re: Calculated Dimensions

alexandros17 — Fri, 15 Mar 2013 13:33:13 GMT

... missing ' ...

final version

IF(MATCH(LOAD_LOC_REF,'USA','NLD','FRA'),LOAD_LOC_REF,

IF(MATCH(DISCH_LOC_REF,'USA','NLD','FRA'),DISCH_LOC_REF,null())

)

Re: Calculated Dimensions

danielnevitt — Fri, 15 Mar 2013 17:04:22 GMT

Hi,

Thank you very much for your help.

Regards,

Daniel