Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

linoybar
Valued Contributor

Promoting columns in the sort tab not getting saved

Hey,

I have a straight table with dimensions and expressions, and I want it to be sorted by one of the expressions.

So I promoted this expression to the highest priority on the sort tab.

Then I saved the document.

But when I open it again - the sort order returns to the original one!

Can someone tell me why is that happening and how to fix it?

Thanks!

1 Solution

Accepted Solutions
linoybar
Valued Contributor

Re: Promoting columns in the sort tab not getting saved

I've wrote about this issue to the Qlik Support and that's the answer I've got from them:

Dear Linoy,

I have tested the issue with the sample QVW you have provided me. I am able to replicate the issue and I also confirm that the workaround that tested is valid as well. Please note that the client build version of desktop you are currently using 11.20.12018 (11.20 SR 3) is no longer patchable.

  I was am able to replicate the issue in 11.20 SR 7 our latest version of QV developer. I can log this issue as a bug, just know that it will probably get a low priority and the timetable for if/when the bug is approved and fixed is will be unknown.



So it's a bug...

I hope they fix it soon.

View solution in original post

18 Replies

Re: Promoting columns in the sort tab not getting saved

Hi,

Can you share a sample to look through.

Regards

ASHFAQ

vardhancse
Valued Contributor III

Re: Promoting columns in the sort tab not getting saved

If we promote and save.

We can see the changes.

But not sure why u are not getting that.

Sharing any sample QVW can understand your correct issue

Not applicable

Re: Promoting columns in the sort tab not getting saved

Hi Linoy,

If its just the matter of display then drag the desired expression to the destination and then save it or attach a sample as suggested by Ashfaq.

Thanks

Re: Promoting columns in the sort tab not getting saved

Hi,

This is really strange behaviour, I have never heard about it.

Are you sure after setting new sort priority You pressed Apply and then OK.

and then saved document.

Just verify it before closing document that changes is applied to it or not.

So that we can know that this behaviour happened after closing document or it is not applying that sort Priority.

Just check it and let us know when this behviour actually happened?

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Partner
Partner

Re: Promoting columns in the sort tab not getting saved

Recreate the same object. It should work.

Regards,

Nirav Bhimani

linoybar
Valued Contributor

Re: Re: Promoting columns in the sort tab not getting saved

In the attached qvw please press on Show Goals Report --> Instant --> < 6000 and then the report will show.

I need to sort it by Net Sum $ desc.

So if you promote it in the Sort tab you'll get the right order.

Then, press on Hide Goals Report and then if you open teh report again - the sort order is still OK.

Now, if you save the document while the report is opened - next time you open the document, the sort order remains OK.

BUT IF YOU CLOSE THE REPORT AFTER PRESSING ON "HIDE GOALS REPORT" AND SAVING THE DOCUMENT, THEN NEXT TIME YOU OPEN IT THE ORDER WILL GET BACK TO THE ORIGINAL ONE!

Re: Re: Re: Promoting columns in the sort tab not getting saved

Hi,

Look at the attached application

I followed your steps and it worked for me.

The only thing I did is to save application after applying sort.

Let me know if that work.

Regards

ASHFAQ

linoybar
Valued Contributor

Re: Promoting columns in the sort tab not getting saved

Hi All,

I've shared the sample QVW as a reply to Ashfaq Mohammed.

Re: Re: Re: Promoting columns in the sort tab not getting saved

Hi,

Yes, I do replicate the same.

I think you must contact support with this case.

Regards

ASHFAQ