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: 
Not applicable

Show Dimension in column

Hi

I want to show G/L Code dimension in column so that columns are not fixed but change based on G/L codes.

Can I do this?

Regards

Anu

1 Solution

Accepted Solutions
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi ANu,

You can just drag G/L Dimension to horizontal and you will be done

View solution in original post

4 Replies
Not applicable
Author

you want to show GL codes in columns......instead of rows......

I think this is ur problem......for this you can apply crosstable.

regards

vijit

Not applicable
Author

yes. Thats right Vijit.

How to apply crosstable?

vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi ANu,

You can just drag G/L Dimension to horizontal and you will be done

Not applicable
Author

1. go to script.

2. select data from table files.

3. then click on next button.

4. then click enable transformation step.

5. then click next.

6. in the prefixes select crosstable.

7. then give parameters.

8. qualifier fields(give no.) - which you want to remain unchanged.

     attribute field - GL codes(name of the field)

    data field - codes (which GL codes show).

9. then ok and finish , crosstable gets created, reload the script.