Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How to filter values in a bar chart based on filtered values from a 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 Reply
Highlighted

Re: How to filter values in a bar chart based on filtered values from a dimension

Would you be able to share a sample to show what isn't working?