Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jorgeblat
New Contributor II

How to filter criteria in a chart based on a left selection of values from a specific dimension?

Hi,

I am really new to Qlik and i need to filter data in order to only process that portion on a single sheet

I can defend myself on Tableau but Qlik seems very different.

I have created a calculated dimension called "Dimension2" with the following formula:

if(match(left(details, 19),'DataRoam Unlimited:'), details)


Dimension2 = If match from char 1 to 19 of "details" dimension, show the dimension value match in that same row in "details"


I am expecting to only show as the dimension values with a match in a bar chart with the sum of a measure related to that dimension as long as it is matched based on the truncation rule of 19 characters.


With this formula I am still getting the entire list of values of the dimension so the filtering/matching i devised is not working at all.

1 Solution

Accepted Solutions
jorgeblat
New Contributor II

Re: How to filter criteria in a chart based on a left selection of values from a specific dimension?

Your post kept me thinking...

Filtering by a calculated dimension doesn't work, I am not fully sure why,

The solution was to create a calculated field in the Data Model viewer with the following formula:


if(left(details, 19)='DataRoam Unlimited:',details)

So combining Paul's and Jahanzeb's suggestions solved the problem.

Thank you!

5 Replies
MVP
MVP

Re: How to filter criteria in a chart based on a left selection of values from a specific dimension?

Would you be able to share an image or a sample to show the issue?

zebhashmi
Valued Contributor

Re: How to filter criteria in a chart based on a left selection of values from a specific dimension?

if(left(details, 19)='DataRoam Unlimited:',details)

paul_scotchford
Valued Contributor

Re: How to filter criteria in a chart based on a left selection of values from a specific dimension?

Coming at this from the left field per se, perhaps if you look at the data model and ascertain if dimensioning products as a dimension, by this I mean if "DataRoam Unlimited" is a product then would items such as this be better served in the loaded model rather than the calculated dimension ? This would be more performant especially if you have a large dataset.

jorgeblat
New Contributor II

Re: How to filter criteria in a chart based on a left selection of values from a specific dimension?

Your post kept me thinking...

Filtering by a calculated dimension doesn't work, I am not fully sure why,

The solution was to create a calculated field in the Data Model viewer with the following formula:


if(left(details, 19)='DataRoam Unlimited:',details)

So combining Paul's and Jahanzeb's suggestions solved the problem.

Thank you!

jorgeblat
New Contributor II

Re: How to filter criteria in a chart based on a left selection of values from a specific dimension?

However it doesn't work as a calculated dimension but rather a calculated field using the data model editor