Dears
I had met a question from straight table into cross table in Qliksense script.
1,table1:straight table
| CustomerNo |
Period |
Catergory |
Value |
| A |
2022-01 |
out_of_warranty |
10 |
| B |
2022-01 |
out_of_mc |
20 |
| C |
2022-01 |
out_of_warranty |
10 |
| D |
2022-01 |
out_of_mc |
20 |
| A |
2022-01 |
out_of_warranty |
10 |
| B |
2022-01 |
out_of_mc |
20 |
| C |
2022-01 |
out_of_warranty |
10 |
| D |
2022-01 |
out_of_mc |
20 |
2,table2:crosstable
| CustomerNo |
Period |
out_of_warranty |
out_of_mc |
| A |
2022-01 |
1 |
1 |
| B |
2022-01 |
1 |
2 |
| C |
2022-01 |
2 |
2 |
| D |
2022-01 |
1 |
1 |
| A |
2022-01 |
1 |
1 |
| B |
2022-01 |
1 |
1 |
| C |
2022-01 |
1 |
1 |
| D |
2022-01 |
1 |
0 |
who can help? Thank you so much.
