Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have created a Tally Data Extractor to load data into Qlikview.
I am getting textual data of Tally but not getting any numeric values but field getting loaded.
Can some body help why I am not getting numeric values of tally into QV?
Does it required any standard format to get Tally numeric field values into Qlikview?
Regards,
Balraj
Hi,
Try
text(yourfield) as Field
Regards
ASHFAQ
Hi Balraj,
Are you extracting the data directly from Tally to Qlikview or you store the Tally data in flat file and then use it in qlikview.
Regards,
Jagan. V
not working
I am directly extracting from tally ......
Hi,
Make sure you use that function while loading from database.
Its worth going through this post.
http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/07/automatic-number-interpretation
Regards
ASHFAQ
I have tried but not getting the result...
Any other solution????
Hi Balraj,
When you load the data into QlikView use the num() function.
Example:
[TALLY DATA]:
LOAD
num(Field) as NewField;
SQL SELECT *
FROM [xxx].[xxx].[xxx]
Regards,
Marius
Send me your script part.
Regards
ASHFAQ
Marius,
I have already tried these things but not giving any numeric values, filed is still blank/null.
Regards,
Balraj