Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kumarreddy257
Contributor

problem with Data type in QVX fil

Hello Experts,

I have a problem with data type in qvx.

I have column status in qvx and data type as unknown. From here I am converting this qvx as qvd and from here we are using in reports.

Here is the problem when we assign status={'open'} in set analysis it is giving blank result. If convert explicitly as string(eg:  text(status) as test_status) then it is working fine. But I don't want to use as explicitly. Is there any to convert this one as string when loading data into QVD.

Please can anybody suggestions.

Regards,

Kumar

Community Browser