dual function issue on qlik view

[#1]

I have attached the sample QVW file

In the Data details tab,

They are two tabs in the attached sample QVW file, Here i have to hide One Identity columns so that i have used dual fucntion but while import in to excel Numric values is coming, i don't want to see the numeric values, to see only text

if there is not text it should be blank, to see in below 8 is coming (Blue color)

Enrollment	Jan
Number of Enrollees At Beginning of The Month	750
New Enrollees In Current Month	605
Enrollees moved from Re-Engagement Process
Enrollees moved to Re-Engagement Process
Enrollees Terminated In Current Month	5
Number of Enrollees at End of Current Month	1350
8

i have used same logic on Dashboard tab working in fine, why it is not working same login on data details

Can you please let us know any one of you have an idea about this issue

[jagan]

Hi Sugunakar,

I didn't see any 8 in your qlikview file, anyway if you want to restrict numeric values then use like this

Data:

LOAD

*

FROM Datasource

WHERE IsText(DimensionName) = -1;

This way you can prevent loading numeric values.  Hope this helps you.

Regards,

Jagan.

[#3]

Hi Jagan Mohan,

I thought you have look at DashBoard tab, it is working fine for DashBoard tab, Can you please look at the DataDetails tab, I have tried as you mentioned above logic but it is not working.

Please let me know if you would have alternative idea on that issue.

Regards,

Sugunakar