Binary qvw file or source files for Data Visualization

[qlikviewwizard]

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.

[its_anandrjs]

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

[qlikviewwizard]

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.

[its_anandrjs]

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

[qlikviewwizard]

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.

[its_anandrjs]

Hi,

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

Regards

Anand

[jagan]

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.

[qlikviewwizard]

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.

[qlikviewwizard]

Any help on this,please.

[jagan · Accepted solution]

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.