topic Re: Move the dimension in QlikView

change position

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

Hi All,

Bala Bhaskar

i want to display the one dimension as last column means after the measure

i have 3 requirments in straight table is working as expected

so i want that to be reflected same in pivot table and Adhoc report table aswell

is there any work around?

PFA. sample

Thanks

Sony

Re: Move the dimension

BalaBhaskar_Qlik — Fri, 17 Aug 2018 07:50:53 GMT

Is drag and drop(Move the dim) of Dimensions in different areas, of straight table not worked?

Re: Move the dimension

soniasweety — Fri, 17 Aug 2018 07:51:46 GMT

stright table is working fine. i need in pivot table and adhoc table

Re: Move the dimension

PrashantSangle — Fri, 17 Aug 2018 08:00:57 GMT

in pivot table you can not drag dimension to end of measures.

Is your adhoc report is straight table or pivot table??

regards,

Re: Move the dimension

andrey_krylov — Fri, 17 Aug 2018 08:04:17 GMT

No, you can not move dimension after expression in pivot. As an option to create expression reflecting your dimension.

Re: Move the dimension

soniasweety — Fri, 17 Aug 2018 08:04:23 GMT

adhoc is straight table only

Re: Move the dimension

PrashantSangle — Fri, 17 Aug 2018 08:55:20 GMT

Hi,

in adhoc straight table,

first un-hide all dimension and measure, then drag your dimension which you want move to end.and again hide dimension and measure.

Regards,

Re: Move the dimension

soniasweety — Fri, 17 Aug 2018 09:06:03 GMT

Im not understood completely .I attached sample could you please help on that?

Re: Move the dimension

BalaBhaskar_Qlik — Fri, 17 Aug 2018 09:08:49 GMT

Check these:

https://community.qlik.com/docs/DOC-6046

https://community.qlik.com/docs/DOC-5404

Re: change position

manoj217 — Fri, 17 Aug 2018 11:39:52 GMT

We can drag the dimension in ui and we can place where ever we want.

Re: change position

PrashantSangle — Fri, 17 Aug 2018 11:53:08 GMT

Yes you are right, but if there is any hidden field in table then we can not drag it to end.

that's why I have suggested him to 1st unhide all expression i.e. remove conditional show from expression and dimension tab arrange that dimension at end.

Then again apply all show conditional statement.

Regards,

Re: change position

manoj217 — Fri, 17 Aug 2018 12:02:01 GMT

Yes true prashant first he need to arrange the position then only we perform the conditions

Re: Move the dimension

manoj217 — Mon, 20 Aug 2018 07:03:53 GMT

please mention what is that option how to acheive that