Chart filters not working

[hadardo]

I have a data model of a "Master Calendar" associated with a link table that holds the date, the date "event type" (e.g. lead creation date, sale date, etc.) and the ID of the lead. For data integrity checks, I tried to create a very simple chart table showing me the IDs of the leads created on certain dates. I added the Date Type dimension on the "Filters" pane of the table chart and selected one of the values, but the table is not being filtered at all. 

Any thoughts on what I'm doing wrong?

Thanks

Applying filters to chartChart not filtered 

[Vegar]

It could be set analysis ignoring your selections. What does the expression you are using in that table look like? Are they containing any set analysis?

8f so, then adjust the expressions so they respect your selections 

[hadardo]

Thanks for the reply. However, why is the chart filter dependent on the existence of a measure in the first place? The filter works as expected if I use the same field I want to filter by at the app level (on the sheet and not on the chart). From a product level, that doesn't make any sense.

[Vegar · Accepted solution]

What you are experiencing is not the default behaviour for tables, but if my suspicion is correct then the developer decided (by using set analysis) to ignore the selections you do on that field. 

Is it possible for you to share the measure expression or verify that is is using set analysis that ignores your selections on that field?

Also worth mentioning is that qlik does not distinguish between clicking a value in a table/graph or clicking it any other place in the application.

[Lech_Miszkiewicz]

Hi @hadardo 

You have used very "unnatural to Qlik" feature which is only available in simplified authoring mode which (i personaly hate). That is the feature which changes underlying JSON (qContextSetExpression) of the object with the hardcoded filter using.

I would remove this chart and I would just enable standard (advanced) and build your chart again. Then you can just select values simply by clicking on them in the chart.

Lastly if we were to comment on why your date filter is not working we would probably need to see how you load your dates and how you model it into master calendar. There could be potential traps like timestamps instead of dates or different data types or even worse autogenerated calendar!!!

The feature was described here: 

https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyp...

https://community.qlik.com/t5/App-Development/New-Simplified-Authoring-Mode/td-p/1960761

cheers

[hadardo]

Thanks @Vegar , yes, I do understand that this is a measure issue. My puzzlement is due to the fact that a measure is even required to begin with. If I want to see just the dimensions values available by a filter which is detached from the model (which "intuitively" what filters are supposed to do). While this may not be a "proper" data analysis object, such reports have their operational purpose.

[hadardo]

Thanks @Lech_Miszkiewicz ,

Perhaps I didn't explain myself correctly. There is nothing wrong with the date table or the date-link table. I want to filter the table based on a "date type". The date filter works just fine, but if the table doesn't carry a measure, the chart filter will simply not work.

So, basically, I agree with you about that feature. Seems a bit half-baked.

[Lech_Miszkiewicz]

yes @hadardo - it is half baked and hence shouldnt be used until it gets better overhaul.

Why dont you just apply regular selection without using the filter "half-baked" feature? It would be simpler and more intuitive as we used to do for last 31 years utilizing Qliks asociative engine 😄

cheers

[hadardo]

@Lech_Miszkiewicz because it not a selection. It should function as a "report widget" with "dimensions values" only and without measures (yes, I'm aware this may not be considered as a proper BI purpose), but such "list report" has its purpose, such as a daily list of leads and actions to each agent. This is why this object needs to be filtered, instead of using AGGR(ONLY... on each dimension column.

Thanks!