topic Binary qvw file or source files for Data Visualization in QlikView

Binary qvw file or source files for Data Visualization

qlikviewwizard — Thu, 02 Apr 2015 01:51:15 GMT

Hi All,

Could anyone provide the Binary qvw file or source files for Data Visualization sample QV file.

It will help me to better understanding of the datamodel design.

Thanks in advance.

Re: Binary qvw file or source files for Data Visualization

its_anandrjs — Thu, 02 Apr 2015 02:20:20 GMT

Hi,

You need Data Visualization file or the source file better you can create from the binary load of the DataVisualization file.

Find the attached Data Visualization file.

Regards

Anand

Re: Binary qvw file or source files for Data Visualization

qlikviewwizard — Thu, 02 Apr 2015 02:40:03 GMT

Hi Anand,

I have this file too.

Even I have the script. But as part of source data analysis I want the source files or data.

Stocks:
LOAD
    date(addmonths([Time-Date], $(vStockAdjMonths))) as [Stock Date],
    date(addmonths([Time-Date], $(vStockAdjMonths))) as [Date],   
    [Adj. Close],
    [Adj. High],
    [Adj. Low],
    [Adj. Open],
    High,
    Low,
    Open,
    Volume
FROM
[Stocks.xls]
(biff, embedded labels, table is Sheet1$)
WHERE date(addmonths([Time-Date], $(vStockAdjMonths))) < $(vTodaysDate);

I want Stocks.xls file to analyse the real data.

Please help.

Re: Binary qvw file or source files for Data Visualization

its_anandrjs — Thu, 02 Apr 2015 02:52:38 GMT

Hi,

I provide you the Stocks.xls file but in this file [Time-Date] field is renamed to [Stock Date] but you can create it from this file also.

Regards

Anand

Re: Binary qvw file or source files for Data Visualization

qlikviewwizard — Thu, 02 Apr 2015 03:02:19 GMT

Dear Anand,

Kindlyprovide remaining files also.

Presidents.xls

General Ledger.xls - Account Balance tab

General Ledger.xls -Account Master tab

General Ledger.xls -Report Format tab

SalesDetails.qvd

Customers.qvd

SalesRep.qvd

ReportsTo.xls

ItemMaster.qvd

Budget.qvd

Thank you.

Re: Binary qvw file or source files for Data Visualization

its_anandrjs — Thu, 02 Apr 2015 03:21:30 GMT

Hi,

I have Stocks.xls file right now provide you later.

Regards

Anand

Re: Binary qvw file or source files for Data Visualization

jagan — Thu, 02 Apr 2015 03:30:50 GMT

Hi,

You do a binary load into another file and use below files to generate the CSV or QVD

Binary [Data Visualization.qvw];

STORE ItemMaster INTO ItemMaster.qvd;

STORE Presidents INTO Presidents.csv;

Hope this helps you.

Regards,

Jagan.

Re: Binary qvw file or source files for Data Visualization

qlikviewwizard — Thu, 02 Apr 2015 04:33:14 GMT

Dear Jagan,

I agree with you. But these tables are already transformed as per the front end dashboard requirement.

I want the raw data files.

Thank you.

Re: Binary qvw file or source files for Data Visualization

qlikviewwizard — Mon, 06 Apr 2015 01:12:57 GMT

Any help on this,please.

Re: Binary qvw file or source files for Data Visualization

jagan — Mon, 06 Apr 2015 02:11:11 GMT

Hi,

It is not possible, because the Binary load will have transformed tables, so you have save as qvds before transforming the data.

Regards,

Jagan.