How to create a butterfly table in Qlik Sense

[marychen]

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!

[Quy_Nguyen]

Hope this help How to create a Butterfly (Tornado) Chart in Qlik Sense

[marychen]

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]

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

[marychen]

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]

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

[marychen]

Monthly Actual	Monthly Budget	Account ID	YTD Actual	YTD Budget
xxxx	xxxx	Account1	xxxx	xxxx
xxxx	xxxx	Account 2	xxxx	xxxx

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

[Quy_Nguyen · Accepted solution]

Hi,

Is this what you are looking for?

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

[marychen]

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]

You are welcome