topic PIXEL PERFECT REPORTING in QlikView

PIXEL PERFECT REPORTING

vikasmahajan — Sat, 03 May 2014 10:50:54 GMT

Dear All,

How to create pixel perfect reporting in Qlikview , Please find attached file format I want to develop from Qlikview

I came to know from community that we have so many third party tools are available for the same , But same thing we can not achieve through Qlikview ?

Experts Please give your suggestions.

Vikas

Re: PIXEL PERFECT REPORTING

tresB — Sat, 03 May 2014 10:55:26 GMT

What do you mean by pixel perfect reporting? Exact format? It seems that your attached format reporting can be done using qlikview pivot table. Isn't it so?

Re: PIXEL PERFECT REPORTING

vikasmahajan — Sat, 03 May 2014 10:58:58 GMT

but see columns like how to bring this ?

Gross Sale
Qty	Value

Vikas

Re: PIXEL PERFECT REPORTING

swuehl — Sat, 03 May 2014 11:10:54 GMT

Having a column for Gross Sale spanning two columns for Qty and Value is standard behaviour in a pivot table, as long as either 'Qty' and 'Value' are dimension values of a field which are linked to the dimension value 'Gross Sale' of the upper dimension or two expressions.

I think one issue is probably that you want to show percentages for the target and absolute values for the other columns, so maybe you need to create a (data island) data model with your columns layout, then having one expression that executes the correct stuff in a pick(match() ) context.

There are some examples in the forum how to do this.

If you are really asking for pixel perfect reporting, IMHO QV is not the right tool.

Re: Re: PIXEL PERFECT REPORTING

tresB — Sat, 03 May 2014 11:11:31 GMT

You can tweak a bit in the script and get it like attached sample.

Re: PIXEL PERFECT REPORTING

vikasmahajan — Sat, 03 May 2014 11:31:40 GMT

I thing directly it will not possible but we have some work around like Treseco Said .

Thanks to all

Vikas