Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pawwy1415
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
vinieme12
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?

mark6505
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 so you can add a flag to your load script like below

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

pawwy1415
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

vinieme12
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

pawwy1415
Contributor II

Re: Calculated Dimension in Qlik Sense

it's not working..

mark6505
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

pawwy1415
Contributor II

Re: Calculated Dimension in Qlik Sense

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

mark6505
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

vinieme12
Esteemed Contributor II

Re: Calculated Dimension in Qlik Sense

Please post a sample!

Community Browser