12 Replies Latest reply: Oct 23, 2017 2:27 PM by Ruben Marin

# Calculated Dimension in Qlik Sense

Hi,

I want to apply wild match ..

e.g. we have A, B, C,D - 4 dimension and we want to show data where

E = *top* and F = *DEAL*..

We don't want to show E and F column in straight table.. just A, B,, C and D column

• ###### Re: Calculated Dimension in Qlik Sense

instead of calculated dimension why not just that to the set analysis of your expressions?

anyway  can you post a sample?

are A,B,C,D field values or different fields?

• ###### Re: Calculated Dimension in Qlik Sense

Hi there,

Could you please give some more details.

From the above I assume A, B, C, D are dimensions on a table.

Are E and F dimensions on the same table

IF(E = '*top*',1,0) as TopFlag,

Then you can use this as a filter?

Or add the expression on your table as TopFlag = 1, then hide the column by making it as small as possible and changing all text colours to white.

Mark

• ###### Re: Calculated Dimension in Qlik Sense

Hi,

A

B

C

D

are different dimensions columns

E

F

are also different dimension column

In straight table, we just want to show A, B,C,D dimensions, users don't want to see E and F column in table else I could apply below

=If(wildmatch([E],'*top deal*'), [E])

=If(wildmatch(F,'*coo*'), F)

How can I apply this logic in front end without using these columns in frontend table..likely want in front end only..

could we do something..=If(wildmatch(CCFileSource,'*coo*', [Metric Data Element],'*top deal*'), CCFreeText)

but it's not working

• ###### Re: Calculated Dimension in Qlik Sense

You should really be adding these conditions to the expressions of your table

otherwise use the only() function to filter each column, A,B,C and D, but i must say i would not recommend it!

Example for A

Keyfield  should be the field that uniquely identifies each rows separately

= AGGR( only({<E={'*top*'},F={'*Deal*'}>} A) , Keyfield)

,repeat these for other columns

• ###### Re: Calculated Dimension in Qlik Sense

it's not working..

• ###### Re: Calculated Dimension in Qlik Sense

This should work, why it's not working?

Please check the attachtment with an example.

• ###### Re: Calculated Dimension in Qlik Sense

there is no attachment

• ###### Re: Calculated Dimension in Qlik Sense

Hi, I'm seeing it, don't you see this?:

• ###### Re: Calculated Dimension in Qlik Sense

Hi

You could try using the below calculated Dimensions

IF([E]= '*top*' AND [F] ='*DEAL*', [A])

IF([E]= '*top*' AND [F] ='*DEAL*', [B])

IF([E]= '*top*' AND [F] ='*DEAL*', [C])

IF([E]= '*top*' AND [F] ='*DEAL*', [D])

If that does work try like instead of equals.

Mark

• ###### Re: Calculated Dimension in Qlik Sense

Is there anyway we can hide column in Qlik Sense as that wil solve my problem?

• ###### Re: Calculated Dimension in Qlik Sense

As far as I am aware this is not possible in Sense yet, Just QlikView.

The only options i can think of is either via calculated dimensions or script.

Mark