Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Multiple columns, one filter

Hi All,

I have 3 columns that displays what qtr a KPI is in.  I want to use one key filter to display all data that belongs to the filtered qtr.  This is what my data looks like:

RecordKPI1KPI2KPI3
1QDEC16QDEC16QDEC16
2QDEC16QMAR17QMAR17
3QDEC16QDEC16QMAR17
4QSEP16QDEC16QMAR17

If I filter by KPI3 data of QDEC16, I only want to see the following records:

  • KPI1 - Record 1,2,3
  • KPI2 - Record 1,3,4
  • KPI3 - Record 1

How can I do this?  My brain is having difficulty.

Thanks!

1 Reply
MVP
MVP

Re: Multiple columns, one filter

Not really sure I understand how you are planning on viewing this?