Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am new to Qliksense, I am having the below requirement.
I am having the below sample data and i need to convert my columns data into Row wise.
Mentioned the desired out put as followed by sample data.
Sample Data:
Account Number | UserID |
101 | UserID1 |
101 | UserID2 |
201 | UserdID1 |
301 | Null |
301 | UserdID2 |
301 | UserdID3 |
Desired Output:
Account Number | UserCount1 | UserCount2 | User Count3 |
101 | UserID1 | Null | Null |
101 | Null | UserID2 | Null |
201 | UserID1 | Null | Null |
301 | Null | Null | Null |
301 | Null | UserID2 | Null |
301 | Null | Null | UserID3 |
Please help me with the situation by using Qliksense Script. Thanks in Advance.
Regards,
QVQS14
Hello QVQS14,
There is no direct pivotting option in qlik scripts, but a combination of generic load and joining does the job.
Rob has a good explanation for your use case in his blog:
https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/