topic Show Dimension in column in QlikView

Show Dimension in column

Thu, 12 Jan 2012 10:04:28 GMT

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

Thu, 12 Jan 2012 11:10:34 GMT

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

Thu, 12 Jan 2012 11:12:55 GMT

yes. Thats right Vijit.

How to apply crosstable?

vijay_iitkgp — Thu, 12 Jan 2012 11:19:38 GMT

Hi ANu,

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

Thu, 12 Jan 2012 11:21:43 GMT

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.