Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prashanth4u
Contributor
Contributor

crosstab

hello qlik Community this is prashanth.i'm new to qlik sense and was hoping you could help me

am attaching Excel file and requriements. 

 

  1. Load and Crosstab “IMS Raw Data_Bio.xlsx” in Qlik with following columns:

Sandoz_Region

Country

Corporation

Molecule_List

Int._Product

Pack

NFC123

Metrics

Data_Month

Data

 

  1. Column header - “Metrics” with identifiers Sales and Volume (rename std_units)
  2. Column header – “Data Month” with months in format “MMM-YY”
  3. Column header – “Data” with entire Sales/Volume data

Thanks in advance.

1 Reply
Wlad_Masi
Employee
Employee

Hello @prashanth4u,

 

Here is a good start point for you to achieve your goal:
Working with crosstables in the data load script
Crosstable

 

As a new user I would also suggest you search on the main search bar on community. Here is an example of things you may find:
Cross table in qlik sense
Change Date Format to MM-YYYY in Qlik Sense
Dealing with date formats in QlikView and QlikSense

I hope it helps you.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.