Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist
‎2017-09-11 02:34 AM

Cross table

Hi all,

I want to convert the following columns vertically as Branch

0854 - GXWFI0855 - GXOAS0857 - GXBU10859 - GXGAZ0860 - GXFRA0861 - GXHDB0862 - GXPLD0863 - GXNHD0864 - GXHMN0865 - GXMAC0866 - GXARM0868 - GXTCM0869 - GXFRD0870 - GXNTT0872 - GXUAQ0873 - GXMZY0874 - GXBRJ0877 - GXQOZ0878 - GXDIA

and following columns vertically as hypermarket

AjmanDeiraAl Saqr ADHRAK ManarMarina MallJimmy MallSharjahShindagaCentury MallMall of EmiratesAl Ain BawadiRAK Zaith 2Dalma Store AUHMirdiffBaniyasFuj Cent Mall

pls find the attached excel.

Regards,

Joshua

Preview file
9007 KB
2,611 Views
0 Likes
10 Replies
ajsjoshua
Specialist
Specialist
‎2017-09-15 02:28 AM
Author

In response to Anil_Babu_Samineni

Dear Anil,

While executing it i am getting only express total quantity in data but i also want the express total sales data.

Regards,

Joshua.

266 Views
0 Likes