Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

matrix visualization

I need to display a visual table that contains two different dimensions in rows/columns and fact data

in each column.

Assume we have two DB-tables:

ChannelTypes - with columns:

     ChannelTypeID  int

     ChannelTypeDesc varchar(50)

BudgetTypes - with columns

    BudgetTypeID int

    BudgetTypeDesc varchar(50)

and a third DB-table that contains the facts:

factTargets - with columns:

     BudgetTypeID int

     ChannelTypeID int

     Amount double

Then the first row in the visual table should display the relevant ChannelTypeDesc

and the first column in the visual table should display the relevant BudgetTypeDesc


                                  BudgetA        BudgetB        BudgetC     BudgetD

ChannelTypeA      sum(amount)    sum(amount)  .....

ChannelTypeB      sum(amount)   .....

ChannelTypeC      ....

ChannelTypeD


This type of visual can be easily created in PowerBI using the "Matrix" component,

but I can't find a way to do this in QlikSense.


Thanks in advance !

2 Replies
rittermd
Honored Contributor

Re: matrix visualization

If you only have the 4 Budget Types this could easily be done in a straight table using some SetAnalysis in your measures.

So ChannelTypeDesc would be your Dimension.

Each measure would be Sum({<BudgetTypeID={'1'}>} amount)

                                    Sum({<BudgetTypeID={'2'}>} amount), etc.


I think that would work based on what you described.

Not applicable

Re: matrix visualization

Hi Mark

thanks for your reply - no it's not only 4 it's as many rows as found in the DB-table, that was only an example.

I managed to resolve this, using a pivot table by clicking the "Fully expanded" checkbox under Appearence/Presentation