topic Re: Qlikview Straight Table: filter data by row and column in QlikView

Qlikview Straight Table: filter data by row and column

Anonymous — Wed, 01 Oct 2014 19:50:39 GMT

When I click on a row within a straight table (as below) I get the row dimension added to my 'Current Selections'. This is great 99% of the time. However, I have a need to provide filtered results based off both the row dimension AND the column dimension.

Example of my need: If I click on 'Numeric Value 1' in the table below my 'Current Selections' box would update with 'Country A'. I would like to have 'Current Selections' update with BOTH 'Country A' and 'Sales Pipeline Status A', so that my adjoining tables have both filters applied to them. Note: 'Sales Pipeline Status A' is a valid field in my database table, not just the 'Label' name for my column header.

Example Table (note: 'Sales Pipeline Status A' and 'Sales Pipeline Status B' are database fields available in my internal QV tables:

Country	Sales Pipeline Status A	Sales Pipeline Status B
Country A	Numeric Value 1	Numeric Value 2
Country B	Numeric Value 3	Numeric Value 4
Country C ....	Numeric Value 5	Numeric Value 6

Can somebody explain how I can do this please, if this is indeed possible?

Thank you in advance.

Steve

Re: Qlikview Straight Table: filter data by row and column

JonnyPoole — Wed, 01 Oct 2014 20:01:45 GMT

Are the Status columns represented as dimensions or expressions ? only dimensions will get added to current selections in a straight table. Qlik doesn't know if you clicked on expression1 cell or expression2 cell so no way to pass that into current selects (to my knowledge)

But in a PIVOT table , the column header values can be a dimension and a cell selcetion would apply both the row values and column values to the respective dimensions in the current selections.

So....can you use a pivot table ?

Re: Qlikview Straight Table: filter data by row and column

Anonymous — Thu, 02 Oct 2014 15:24:40 GMT

Hi Jonathan, I'll try your pivot table approach. This makes sense. Thanks for the recommendation.