Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
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(
=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
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
it's not working..
Hi
You could try using the below calculated Dimensions
IF(
IF(
IF(
IF(
If that does work try like instead of equals.
Mark
Is there anyway we can hide column in Qlik Sense as that wil solve my problem?
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
Please post a sample!