topic Re: sort pivot by users in QlikView

sort pivot by users

Anonymous — Thu, 07 Aug 2014 02:53:34 GMT

hi,

is it possible to let the users option to sort pivot table easely ?

thanks'

yarin.

ashfaq_haseeb — Thu, 07 Aug 2014 05:30:43 GMT

Hi,

For straight table you can. But for pivot I don't think its possible.

Regards

ASHFAQ

amit_saini — Thu, 07 Aug 2014 05:37:15 GMT

Yarin,

Pivot table is better for grouping not sorting , it may be possible to sort as below .

Ashfaq is right this sorting by users is possible in straight table but not with pivot.

Thanks,

Thu, 07 Aug 2014 05:45:12 GMT

You Can write Expression in Sort Tab of the Chart .

By this you can customize your Sorting in Pivot Table

ashfaq_haseeb — Thu, 07 Aug 2014 05:54:30 GMT

Hi,

Its about end user.

Regards

ASHFAQ

sujeetsingh — Thu, 07 Aug 2014 06:02:07 GMT

That is just the creativity in script and playing around the variables.

You need to decide all possible options that you want the user to sort on

Then you need to provide a inline field with all possible sortings.

Now there can be a filter which provides different sorting option and when user select any of that then that sorts the table.

Anonymous — Thu, 07 Aug 2014 10:11:50 GMT

hi,

can you please specify more ,

or send an exmple ?

thanks'

yarin.