# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

## 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

12 Replies
Esteemed Contributor II

## 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?

Valued Contributor III

## 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

Contributor II

## 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(,'*top deal*'), )

=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

Esteemed Contributor II

## 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

Contributor II

## Re: Calculated Dimension in Qlik Sense

it's not working..

Valued Contributor III

## Re: Calculated Dimension in Qlik Sense

Hi

You could try using the below calculated Dimensions

IF(= '*top*' AND ='*DEAL*', )

IF(= '*top*' AND ='*DEAL*', )

IF(= '*top*' AND ='*DEAL*', )

IF(= '*top*' AND ='*DEAL*', )

If that does work try like instead of equals.

Mark

Contributor II

## Re: Calculated Dimension in Qlik Sense

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

Valued Contributor III

## 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

Esteemed Contributor II