Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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!

View solution in original post

5 Replies
sunny_talwar

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

zebhashmi
Specialist
Specialist

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

paul_scotchford
Specialist
Specialist

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.

Anonymous
Not applicable
Author

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!

Anonymous
Not applicable
Author

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