leading zeroes for filter selection in URL

[je48746stijn]

Dear all,

we have an external application which constructs an URL towards one of our Qlik Sense apps, together with a filter selection inside it.  Something like this : https://...sense/app/69877437-4e38-4353-b884-e77ea32513c2/sheet/f747c174-50f8-4453-92ba-1d4a0c8e9cec/state/analysis/select/CifNr/0998740. 

However, since the recent update of Qlik Sense to version "May 2021 patch 4", he does not longer accept a leading zero before the number, in this case 998740.  The URL only seems to work when the leading zero is omitted. 

Is anyone aware of this bug and does anyone has a way to resolve this?  The field CifNr is known in the datamodel as being numeric.  Passing the filter with a leading zero inside the URL worked fine before the update.

Many thanks in advance.

Kind regards,

Stijn

[Andrei_Cusnir]

Hello,

If my understanding is correct, then you have the following use case scenario:

1. You have a filed named CifNr
2. This field is Numeric
3. You are trying to construct an URL similar to 'https://../state/analysis/select/CifNr/0998740', which will open a Qlik Sense app and make the selection of 0998740 of the field CifNr
4. However, you have noticed that after upgrading to Qlik Sense May 2021 Patch 4, this link is no longer behave as it used, so the selection is not made.
5. You have an app with links and then the URLs generated in this app are navigating you to different app where the selection is applied

I was trying to reproduce the issue on my side and I have observed the same behavior as you have. However, in my understanding this most probably is working as designed. First we have to see how the data is displayed in both apps. Please share the following information:

1. In app A where the links are constructed, you are getting the numbers '0998740' etc. from the dataset. Can you show a screenshot of the loaded data? (There is no need to share the entire dataset, to avoid exposing sensitive information. I just need to see how that numbers are presented in the loaded dataset)
2. In app B where the links are navigating to and the selection is supposed to be made, you also should have a dataset with the same numbers '0998740' etc. Can you share also a screenshot from that dataset as well? This will help us understand how the dataset looks in the second app as well. 
3. Are both apps using the same Qlik Sense version?
4. You have said that it was working before, which version of Qlik Sense where you using where it was working?

This information will allow us to understand better the use case scenario that you have.

[je48746stijn]

Hi Andrei,

thanks for your response.  Please find here my answers to your questions :

1. I do not have access to the source application.  I only have this constructed URL available.

2. 

3. The first app is not a Qlik Sense app, it's a web application which only constructs the URL to jump to the Qlik Sense dashboard

4. That was the November 2020 version.

Thanks in advance for your help.

Kind regards

[Andrei_Cusnir]

Hello,

Thank you very much for sharing this additional information. The use case scenario is more clear now and it is also clear to me how your setup works. I can also see how the data is presented in your dataset. The only information that I am missing is what kind of value do you see in your dataset for 0998740. Is it 0998740 or 998740? 

This is the result of my preproduction:

1. I had the value "0998740" loaded in my dataset
2. The type is "$numeric $integer" as yours
3. When I access the link https://../state/analysis/select/FIELD/0998740 it works
4. When I access the link https://../state/analysis/select/FIELD/998740 it doesn't work

In my case the value in the dataset is 0998740 so when the exact value with leading zero is passed, it is being selected. But since I don't have any value in my dataset that looks like 998740, the selection is not applied.

Please provide the following information: 

• Can you please doublecheck and confirm that in your dataset you have the exact value 0998740 with the leading zero? From the dataset image that you have sent I can only see 2 digits numbers, and non has a leading zero, so my assumption is that maybe the leading zero is removed from that value or the entire value is no longer present in the dataset and thus Qlik Sense can't find it.
• Additionally, can you please try to load the app in the same Qlik Sense version but in a different environment (different machine), and try accessing the same URL from your browser, to see if the behavior is the same? 
• How many values do you have with leading zero in your dataset? (I say that, as it might affect how the field is interpreted in Qlik Sense)
• Do you experience the same issue with other values in your dataset that contain leading zero or the issue is only limited to few values?

[je48746stijn]

Hi Andrei,

the value I see in the dataset is 998740.  All values are facing the same problem.  There are no values with leading zeroes in my dataset.  My colleagues are facing the same issue, so the problem is also present on other machines. We are all using the same version of Qlik Sense.

kind regards

[Andrei_Cusnir · Accepted solution]

Hello, 

Thank you for the confirmation. If my understanding is correct the link https://../state/analysis/select/FIELD/0998740 is NOT working, but the link https://../state/analysis/select/FIELD/998740 works. If this is the case, then the application is working as designed, because you have confirmed that your dataset contains the value 998740 and not the value 0998740. Therefore, you have to update the application that is creating the links to remove the leading zero and create links where the value is exactly as it is present in the dataset. 

Why it was working previously is unknow, because it could be due to various reasons, however it is a possibility that previously you had values with leading zeros and now those values don't exists or where updated and the leading zero was removed. In any case this is working as designed and if your link tries to select a value with a leading zero as https://../state/analysis/select/FIELD/0998740 then Qlik Sense will check the dataset and will not find any value with leading zero. Since your dataset has the value 998740 and not the value 0998740. This is why it is working if the leading zero is omitted.

To summarize the information:

• The values in your current dataset don't have a leading zero
• Therefore the link needs to be constructed (In the application) without the leading zero
• If Qlik Sense has values 1234, 5678, 9876 in the dataset, but the link tires to select values 01234, 05678, 09876, it will not work as those values are not present in the dataset.

I hope that this information was helpful. In case you believe that I have misunderstood something, or if something doesn't make sense, please elaborate fruther to the use case scenario.