Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Crosstable

HI All ,

Can someone explain me does this works ?

CrossTable(Department, Feedback, 😎

BY this i understand that after 8 fields we need to convert the horizontal data to vertical and bring it within a field  and that field is described as Department .....

what is Feedback here ? Can anybody explain me about this ?

Thanks  in Advance

3 Replies
Highlighted
Partner
Partner

Re: Crosstable

Hi,

8 is for qualifier fields, it will be the same as you can see in the spreadsheet.

Department is for attribute field, the top first line after the 8th column will have this value.

Feedback is for datafield it will be the internal part (rest)  in the spreadsheet.

Hope it will help,

Daniel

Highlighted
MVP
MVP

Re: Crosstable

Consider you have Monthwise Sales data for few Customers as below

Customer, Jan, Feb, Mar

A, 100, 120, 130

B, 200, 120, 400

C, 300, 200, 100

You want to use Crosstable here to convert Customer's monthly Sales

you can use as

CrossTable(Month, Sales, 1)

Here Month is Logical name you have to give.. we know Jan, Feb, Mar are months so we gave them name as Month

Values for Jan, Feb, Mar is Sales for each customer, so we gave Measure name as Sales.


Now you can use the same logic in your question.

HTH

Regards,

MK

Highlighted

Re: Crosstable

As a result, Manish's example will produce a table like:

Customer, Month, Sales

A, Jan, 100

A, Feb, 120

A, Mar, 130

B, Jan, 200

B, Feb, 120

B, Mar, 400

C, Jan, 300

C, Feb, 200

C, Mar, 100