topic Re: Help with dates from JD Edwards in QlikView

Help with dates from JD Edwards

shalensookdeo — Wed, 25 Nov 2020 16:16:04 GMT

Good Day

Please can I kindly seek some ideas to get my months a selectable format. They are currently vertical and named as Net Posting 01 etc etc.

How can i change them that i can actually select them and not the date within the columns?

Thanks

Re: Help with dates from JD Edwards

jonathandienst — Tue, 18 Sep 2018 12:45:31 GMT

I expect that each month here is an expression in a straight table.

To make the months selectable, you will need to create the field in the load script and then change the table to a pivot, add the field as a dimension, edit the expression to remove the month selection and then pivot the months to the top ot make a cross table. Now if you select a month or months, the table will collapse to display only the selected month(s)

Re: Help with dates from JD Edwards

shalensookdeo — Tue, 18 Sep 2018 13:43:00 GMT

Thank you

would you know how i can link this table to it? I think this may work.

Re: Help with dates from JD Edwards

dplr-rn — Tue, 18 Sep 2018 18:48:45 GMT

Did you try crosstable? that way Net Posting 01, Net Posting 02 becomes column values and you can link to above table

Re: Help with dates from JD Edwards

dplr-rn — Wed, 19 Sep 2018 14:00:00 GMT

Any luck?