topic Re: Upload data from Power tables format in QlikView

Upload data from Power tables format

Thu, 30 Oct 2014 16:24:36 GMT

Hi all i have power tables diagram and type data - numeric but then i uploading data i have not good format data

for example in file.

Who can help me

Thank ' you

ashfaq_haseeb — Sun, 02 Nov 2014 08:34:12 GMT

Hi,

From Qv desktop->Help->About QlikView->at the left bottom of new window qlikview symbol(easter egg)

->Right click->ExcelExportMixedAsText ->Set it to '0'

Let me know if that worked.

Regards

ASHFAQ

Fri, 07 Nov 2014 08:42:15 GMT

Hi its good desigion. Its work. But now i show my data in format data upload as 40695. How i can change this?

sujeetsingh — Fri, 07 Nov 2014 08:45:20 GMT

A new way to do so

Fri, 07 Nov 2014 09:23:38 GMT

That do you might? How do

ashfaq_haseeb — Fri, 07 Nov 2014 10:23:54 GMT

Hi use date(yourdatefield) whenever you use date.

Regards

ASHFAQ

Fri, 07 Nov 2014 11:58:06 GMT

My load script use this columns as date, you can show to see in my examples file. Just it is in script or table?

ashfaq_haseeb — Fri, 07 Nov 2014 12:05:21 GMT

Do that in table too

ashfaq_haseeb — Sun, 09 Nov 2014 07:00:53 GMT

Hi,

Check this and let me know if that worked.

Regards

ASHFAQ