topic Filter dimension in object FILTER PANE in Water Cooler

Filter dimension in object FILTER PANE

jmialoundama — Fri, 07 Feb 2020 21:54:52 GMT

Hello,

I have a dimension that contains several codes. I want to filter only codes starting with 15.

I know that it is possible to perform the filtering in the loading script but I use this dimension in other sheets. That's why I want to filter in the sheet instead of the script.

Thank you in advance 🙂

Re: Filter dimension in object FILTER PANE

Stoyan_Terziev — Mon, 18 Nov 2019 14:49:21 GMT

Hello,

If you are talking about Qlik Sense, that would normally require to use set expression or if-statement in your Dimension or Measures. Best practice is to have them as separate master items.

Measures would look like:

Count({<[Code]={"15*"}>} Number)

Dimensions would look like:

If(WildMatch([Code], '15*'), [Code], Null())

In QlikView you can have on-sheet-land trigger.

I hope that helps!

Kind regards,

S.T.

Re: Filter dimension in object FILTER PANE

jmialoundama — Mon, 18 Nov 2019 14:53:45 GMT

Hi Stoyan_Terziev,

Thanks you for your answer , its works perfectly for my dimension

Re: Filter dimension in object FILTER PANE

niha — Sun, 15 Dec 2019 05:00:24 GMT

Hi,
Is your issues resolved? I think it can be done by set analysis. In the modifier, < dimension = {"15*"}>. This may help.