Dual function issue on data details tab

Sun, 24 Nov 2013 06:19:57 GMT

I have attached Sample QVW file.

There is an identity columns in the table. We do'nt want see that identity column row So that i have used Dual function to choose any one of columns to sort on Identity columns.

to see in the attached sample file if you import into excle numric values coming so i do'nt want see the numric values if there is no text it would be blank, but here numbric values coming (to see in blue color values)

can any one help me on this issue

Enrollment	Jan	Feb	Mar	Apr	May
Number of Enrollees At Beginning of The Month	1296	1311	1320	1337	1361
New Enrollees In Current Month	15	12	19	24	13
Enrollees moved from Re-Engagement Process
Enrollees moved to Re-Engagement Process
Enrollees Terminated In Current Month	0	3	2	0	1
Number of Enrollees at End of Current Month	1311	1320	1337	1361	1373
150
Total Volume of Coach Communication	Jan	Feb	Mar	Apr	May
Coach Emails	889	925	318	1064	1159
Coach Journal Responses	0	6	2	22	4
Telephonic Outreach	11	15	11	14	6
In Person Outreach	0	0	0	0	0
Total Volume of Coach Communications	900	946	331	1100	1169
Average Number of Coach Communications to All Members	0.69	0.72	0.25	0.81	0.85
158

Re: Dual function issue on data details tab

afurtado — Sun, 24 Nov 2013 11:13:47 GMT

Hi. I'm not sure, but I could not see. Maybe my QlikView version. I'm using 11.2 SR5 (beta).

Alessandro Furtado

Re: Dual function issue on data details tab

Clever_Anjos — Sun, 24 Nov 2013 20:47:44 GMT

It´s not showing any numbers here either, 11.20 SR4

Re: Dual function issue on data details tab

stevedark — Sun, 24 Nov 2013 23:25:12 GMT

It certainly was an issue back along, the number would always be sent to Excel in place of the text. I think it has been right since version 10 though.

- Steve

topic Re: Dual function issue on data details tab in QlikView

Dual function issue on data details tab

Re: Dual function issue on data details tab

Re: Dual function issue on data details tab

Re: Dual function issue on data details tab