Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

marychen
New Contributor III

How to create a butterfly table in Qlik Sense

I need to create a butterfly table in Qlik Sense with just one dimension and two sets of comparison measurement, one set on the left and the other on the right side. I have one done in QlikView. Can it be done in Qlik Sense? Thanks!

1 Solution

Accepted Solutions
Quy_Nguyen
Contributor III

Re: How to create a butterfly table in Qlik Sense

Hi,

Is this what you are looking for?

bt.PNG

If yes, just create a table object with your dimension and measures then drag/drop them to get the right position.

bt.PNG

9 Replies
Quy_Nguyen
Contributor III

Re: How to create a butterfly table in Qlik Sense

marychen
New Contributor III

Re: How to create a butterfly table in Qlik Sense

I read this butterfly chart yesterday and did one chart in Qlik Sense. But, I need a Butterfly Table. Is it possible to switch the chart into a table? Thanks.

Quy_Nguyen
Contributor III

Re: How to create a butterfly table in Qlik Sense

Could you please provide a picture of the table that you are going to create?

marychen
New Contributor III

Re: How to create a butterfly table in Qlik Sense

The table should have the following row as the header:

Monthly Actual  |  Monthly Budget  |  Monthly Variance  |  Dim_Account_ID  |  YTD Actual  |  YTD Budget  |  YTD Variance

Quy_Nguyen
Contributor III

Re: How to create a butterfly table in Qlik Sense

I mean that i cant imagine what is a butterfly Table.

marychen
New Contributor III

Re: How to create a butterfly table in Qlik Sense

   

Monthly ActualMonthly BudgetAccount IDYTD ActualYTD Budget
xxxxxxxxAccount1xxxxxxxx
xxxxxxxxAccount 2xxxxxxxx

Sorry, I meant to create a table format like the above.

Quy_Nguyen
Contributor III

Re: How to create a butterfly table in Qlik Sense

Hi,

Is this what you are looking for?

bt.PNG

If yes, just create a table object with your dimension and measures then drag/drop them to get the right position.

bt.PNG

marychen
New Contributor III

Re: How to create a butterfly table in Qlik Sense

Thank you Quy. With your screenshot I was able to create the table and move the column order from the Column list instead of trying from within the table object. I am new to Qlik Sense, thank you for the help.

Quy_Nguyen
Contributor III

Re: How to create a butterfly table in Qlik Sense

You are welcome

Community Browser