Building Chart with mentioned functionality

miranrai — Fri, 27 Nov 2015 11:55:12 GMT

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.

Re: Building Chart with mentioned functionality

Clever_Anjos — Fri, 27 Nov 2015 12:49:40 GMT

QlikView does not implement selections based on expression values.

Qlik Sense does

topic Re: Building Chart with mentioned functionality in QlikView

Building Chart with mentioned functionality

Re: Building Chart with mentioned functionality