topic Variable issues in app in QlikView

Variable issues in app

Fri, 01 Sep 2017 14:02:31 GMT

Hello I am building a dashboard with policy and claims data. I have selected a claim and set the corresponding policy number as a variable. The policy number is then passed through another chart which gives me a list of all claims associated with selected policy. When i select a policy number whos characters are all numbers (including leading zeros) the policy drilldown works fine. However, when the variable is set to a policy number whos characters contain a letters and numbers, the leading zeros are removed and the drilldown does not function properly. Does anyone know how i can fix this. I tried to load the policy field as text(policy) in the script and had no luck fixing this issue.

Re: Variable issues in app

vishsaggi — Fri, 01 Sep 2017 14:56:30 GMT

So your policy number comes as Numbers and characters ? May be you can try like in the script

LOAD .....,

if(ISNum(Policy), Policy, text(Policy)) AS NewPolicy

FROM ...;

Try this if not can you share some sample to look into.

Re: Variable issues in app

Fri, 01 Sep 2017 15:01:14 GMT

example of policy number that works : 0000123456 (leading zeros are kept in variable)

example of policy number that does not work: 0000A123456 (variable value = A123456 and no matching policy is found)

i will try loading the script is you suggested

Re: Variable issues in app

vishsaggi — Fri, 01 Sep 2017 15:07:37 GMT

Ok. Try and let me know. BTW how you defined your variable and where exactly you are using this variable can you give me some details?

Re: Variable issues in app

Fri, 01 Sep 2017 15:17:03 GMT

fixed the problem. It was a way the variable was being used in set analysis. Thanks for the help

Re: Variable issues in app

vishsaggi — Fri, 01 Sep 2017 15:20:24 GMT

Can you show how you fixed it so that others can get helped.