topic Multiple data formats in QlikView

Multiple data formats

Mon, 09 Feb 2015 13:52:29 GMT

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.

Re: Multiple data formats

Anonymous — Mon, 09 Feb 2015 14:01:33 GMT

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

Re: Multiple data formats

Anonymous — Mon, 09 Feb 2015 14:04:58 GMT

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?

Serhan