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
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
Labels
Carrefour - January to December 2011.xls
3,197 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.

346 Views
0 Likes