Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a Chart that contains several Dimensions and one Measure. I want to filter one of the dimensions by if it contains the letter X.
I only want to see lines that have the letter X in them.
Event Title Date Amount
Cloth Shopping 1/1/2023 100.00
Food Shopping 2/1/2023 125.000
X - Car Shopping 3/1/2023 55,000.000
I want to filter this chart to only show the Event Title that has an X in it. Is this possible?
It's the same as SUMIF of excel in Qlik or an IF() function embedded in a sum, something like
Sum(If(Condition), Value)
Which is used as a chart expression.
Alternatively, you achieve the same thing using a calculated dimension as below and suppress when the value is null.
If(WildMatch([Event Title],'*X*',[Event Title])
Sum(If(WildMatch(Event Title],'*X*'),Amount))
or
Sum({$<Event Title]={'*X*'}>}Amount)
I tried this
Sum(if(WildMatch([Event Title],'*X*'), Amount))
Why is the else_expr Expression using the Amount?
when i use this, i get an error. Invalid Dimension
I have several lines in my chart with "X", and I want to see all the data on those lines, not just the Amount.
Do i enter this formula in the Show Column IF area?
It's the same as SUMIF of excel in Qlik or an IF() function embedded in a sum, something like
Sum(If(Condition), Value)
Which is used as a chart expression.
Alternatively, you achieve the same thing using a calculated dimension as below and suppress when the value is null.
If(WildMatch([Event Title],'*X*',[Event Title])
thank you so much, that worked!!!