Multiple data formats

[#1]

Is QlikView capable of consuming multiple data formats?  Can it perform against multiple environments?  In many cases we combine data from multiple sources to create a single report – can this be duplicated?  How is this done?

Thanks for the help.

[Anonymous]

Yes.

The most common is the format of the date.  In QlikView, you just use the same format for all data sources.  For example, source 1 has Date as MMDDYYYY - you read it date(date#(Date,'MMDDYYYY')).

Source two has format YYYY.MM.DD - read it as date(date#(Date,'YYYY.MM.DD')).

In both cases, you'll get Date in format defined by

SET DateFormat=...;

in the beginning of the script.

Edit - see this: http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/13/dual

[Anonymous]

Hello,

If you mean data blending from multiple sources, it's one of QlikView's strongest points due to its scripting abilities.

What's your real-life scenario?

BR

Serhan