count row table

[#1]

Hello,

I have this table:

Mentions	Level
text men_1 texr	1
men_1 text	1
text text men_1	2
text text text men_1 text	1
men_2 text	1
text text men_2 text	2
men_1	2
text men_1 text text text	3

How can I rearrange the table in this form?

Mentions	Level_1	Level_2	Level_3
men_1	3	2	1
men_2	1	1

Thank you!

[bhargav_bhat]

Hi Capatina,

You can use Pivot Table feature in Qlikview where you can pull the Level field  in the column.I have attached sample qvw for your reference

Pivot Table ‒ QlikView

Regards,

Bhargav

[#3]

Your example does not work

[bhargav_bhat]

Hi  Capatina,

it is working in my desktop.

Also I have attached Qliksense file