Calculated Dimension in Qlik Sense

[pawwy1415]

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

[vinieme12]

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?

[Mark_Little]

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]

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]

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]

it's not working..

[Mark_Little]

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]

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

[Mark_Little]

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]

Please post a sample!