Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Sneha1
Contributor
Contributor

Qliksense not printing correctly

Hello All,

 

I have tried already text(field) to retain number with leading zeros  and without zeros but still qliksense is not printing it correctly. I cannot see the data in sheet correctly.

 

my code is as below

 

PS_Z_RW_AFFILIATE_TRY1:
SELECT Z_ID_AFFL, FIELDNAME, Z_ATTR_VALUE, Z_DTTM_STAMP,rownum from $(vUS_Sch).PS_Z_RW_AFFL_ATTR where Z_ID_AFFL='1771';
STORE PS_Z_RW_AFFILIATE_TRY1 into [$(vUS_QvdPath)REGW_AFF_ATTR_TRY.qvd](qvd);
Drop table PS_Z_RW_AFFILIATE_TRY1;

PS_PS_Z_RW_AFFL_ATTR_TRY:
Load Z_ID_AFFL, FIELDNAME, text(Z_ATTR_VALUE), Z_DTTM_STAMP from [$(vUS_QvdPath)REGW_AFF_ATTR_TRY.qvd](qvd);

Below is the data in the oracle database

Sneha1_0-1647848767141.png

This is the output that i am getting

 
 

Capture.JPG

 

 

Labels (3)
1 Reply
Anil_Babu_Samineni

Perhaps this and see if that makes OK?

If(Len(Z_ATTR_VALUE)=1, Z_ATTR_VALUE, Text(Z_ATTR_VALUE)) as Z_ATTR_VALUE

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful