Building Chart with mentioned functionality - Qlik Community

miranrai · ‎2015-11-27

Hi,

I need help in building below chart which has functionality if click on any expression value then the data should get filtered out by dimensions in chart (DOA Group & Weighted Avg Group AcCR) + Month for which that value is selected.

Expressions are calculated by month dates which are dynamic if current month is Oct-15 Then Previous Quarter Month of the Current Month (Sep-15), Previous 2^nd Quarter Month(Jun-15), Previous 3^rd Quarter Month (Mar-15), Previous Year (Dec-14) is the logic to calculate these dates And Previous 2^nd Year (Dec-13) (From right to left). My client want to have functionality if click on any expression value then the data should get filtered out by dimensions in chart (DOA Group & Weighted Avg Group AcCR) + Month for which that value is selected. I have populated these dates using variables & used set analysis in expressions.

I tried using pivot table, used month as one of the dimensions and dragged it to column but here issue is its giving me all the month which i don't want . If i use valuelist that functionality of filtering data by dimension and selected value month disappears.

This table has other expressions also QoQ & YoY . How to build this kind of chart with mentioned functionality. Please help.

Clever_Anjos · ‎2015-11-27

QlikView does not implement selections based on expression values.

Qlik Sense does