Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Regards,
Bhargav
Your example does not work
Hi Capatina,
it is working in my desktop.
Also I have attached Qliksense file