Drill down by referring to columnar summation relationship
Hi everyone, and thank you for your help in advance!
Currently I am trying to build a drill-down bar chart, using the data as attached.
My objective is, after importing the data to Qlik, I will add 2 new summation columns: G_Good = G1 + G2, and G_Bad = G3+G4+G5. Then I will Add the G_Good and G_Bad values to the bar chart (x-axis as Date). The G_Good and G_Bad bars should be able to drill down to G1 & G2, and G3, G4, G5 respectively.
However, multiple searches I've done only show how to do hierarchic drill-down if the relationship is directly shown in the data (i.e. in the data, a column which shows G1-G5, and another column mapping G1-G5 to G_Good or G_Bad). Can anyone help show me if it's possible to do the hierarchy drill down without having to change the data structure? Thank you!
In Qlik, drill-down relationships are based on dimension values, not measure values. Since your G_Good and G_Bad are presumably measures, you can't establish a drill-down relationship using them or even select them by clicking on the bar chart. In order to establish a drill-down relationship you would need to unpivot the data, and you specifically requested something that won't change the data structure so I guess that's not an option.
You could work around this by creating two charts, one with G_Good and G_Bad and one with G1-G5, and placing them in a container object. You could also add a filter / variable where the user selects which one they want to see and use that to determine show/hide within the container. Another option might be to use custom tooltips (which, starting with Qlik Sense November 2021, can also include charts) - see https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/custo...
In Qlik, drill-down relationships are based on dimension values, not measure values. Since your G_Good and G_Bad are presumably measures, you can't establish a drill-down relationship using them or even select them by clicking on the bar chart. In order to establish a drill-down relationship you would need to unpivot the data, and you specifically requested something that won't change the data structure so I guess that's not an option.
You could work around this by creating two charts, one with G_Good and G_Bad and one with G1-G5, and placing them in a container object. You could also add a filter / variable where the user selects which one they want to see and use that to determine show/hide within the container. Another option might be to use custom tooltips (which, starting with Qlik Sense November 2021, can also include charts) - see https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/custo...
