Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have 3 tables with them i created few charts. Now I want to add filter Common filter for all the charts, like Filtering with same organisation or like filter with years n months. Associations are giving me expected results but when I click any chart Visualizations rest others charts are getting filtered (May be based on dates or something). Is there others ways to filter. I even tried with variables but they hold single values. Suggest me better solution for this.
Thanks in advance,
🙂
Hi Harry,
You can do like this : Sum({<Customer=,Region=>}Sales). fields that should not affect your chart on selection needs to be listed in the {<here>} braces.
And
for common filter between 2 table scenario a association can do the job but if issues persist we need dummy data set to help you out.
Regards,
Prashant.
Hi Harry,
The filters in Qlik works according to the connection between the tables (Out of the box).
So it all depends on your data, maybe you can share your app, or share the table schema and elaborate more on your problem.
BR,
Eliran.
My problem is after associate 3 tables using date fields, whenever I click on a some chart’s Dimension (Which belongs to table 1) then Automatically filtering rest all charts (which belongs to table 2 n table3).
can’t we stop filtering by clicking on dimensions.
Hi Harry,
One way is there, you can nullify all the fields of table 1 in other chart expression where you don't want the selections to be worked.
Regards,
Prashant
Hi Prasanth,
can u explain how to nullify those fields.
and Do you have any idea how to have a common filter between 2 tables without joining them.
Thank you
Hi Harry,
You can do like this : Sum({<Customer=,Region=>}Sales). fields that should not affect your chart on selection needs to be listed in the {<here>} braces.
And
for common filter between 2 table scenario a association can do the job but if issues persist we need dummy data set to help you out.
Regards,
Prashant.
Two methods working Prasanth, but using first method I have to nullify many fields from different charts, felt second method convenient.
I created 2 dummy dimensions month, year for filtering in filter pane, Used year reference in month filter.
Sep-2020 so I wanna show only months up to September when year 2020 is selected else show all 12 months.
if ( yr = year(today()), if(monthno <= month(today()), Month), Month)
**So when months are selected values Of year are changing. Nullifying can be done only with aggregate measures ? Or can be on dimension too ?
thanks 🙂