Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

count row table

Hello,

I have this table:

MentionsLevel
text men_1 texr1
men_1 text1
text text men_12
text text text men_1 text1
men_2 text1
text text men_2 text2
men_12
text men_1 text text text3

How can I rearrange the table in this form?


MentionsLevel_1Level_2Level_3
men_1321
men_211


Thank you!

Tags (1)
3 Replies
bhargav_bhat
Contributor II

Re: count row table

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

Not applicable

Re: count row table

Your example does not work

bhargav_bhat
Contributor II

Re: count row table

Hi  Capatina,

it is working in my desktop.

Pivot table.JPG

Also I have attached Qliksense file

Community Browser