topic Re: Autonumber() Check in QlikView

Autonumber() Check

amit_saini — Thu, 05 Jul 2018 08:47:51 GMT

Hi Folks,

Document Analyzer is recommending me to change below field in my Dashboard to Autonumber().

Plant & '#' & SZUSINFO1 as %Tank_Key,

So, I have done something like below:

"AutoNumber(Plant & '#' & SZUSINFO1, 'Plant & '#' & SZUSINFO1') as %Tank_Key"

Please check and suggest if script is right or wrong?

Thanks in advance!

Regards,

tresB — Thu, 05 Jul 2018 09:12:13 GMT

May be just (without the second parameter):

AutoNumber(Plant & '#' & SZUSINFO1) as %Tank_Key"

amit_saini — Thu, 05 Jul 2018 09:30:40 GMT

Thanks Tresesco,

But Document Analyzer telling to use second Parameter too.

Let me try with you suggestion and will get back to you.

Thanks,

amit_saini — Fri, 06 Jul 2018 06:50:07 GMT

any suggestions???

Regards,

tresB — Fri, 06 Jul 2018 06:53:20 GMT

Didn't my suggestion work? Could you share a sample app with sample data showing the issue you are facing?

amit_saini — Fri, 06 Jul 2018 06:56:58 GMT

I'm trying this Autonumber () function suggested by Document Analyzer for Dashboard performance enhancement.

When I tried your suggestion , it didn't work , I will try to share sample app.

Regards,

amit_saini — Fri, 06 Jul 2018 11:13:46 GMT

should be like below:

AutoNumber(Plant & '#' & SZUSINFO1,'Tank_Key') as %Tank_Key

Thanks,