topic Re: Report Format in QlikView

Report Format

Anonymous — Wed, 02 Sep 2015 09:40:49 GMT

Hi Friends,

Like to know wether we cab acheive the below report format in pivot table

1. I have two dimension one is salesperson and other is week.

2. we need to see metric self genrated sales count as inverted by week.

3. There are few more expressions that is not needed to be inverted.

dimension1

Expression1

Expression2

Expression3

WEEK

WW27

WW28

WW29

WW30

WW31

WW32

I want to know how can I acheve this?

Regards,

Anant

Re: Report Format

Anonymous — Wed, 02 Sep 2015 10:16:29 GMT

Hi All,

Any Suggestions???

Thanks

Anant

Re: Report Format

Anonymous — Wed, 02 Sep 2015 10:26:08 GMT

Hi Anant,

I have occasionally succeeded in dragging the dimension rows to the top, to make them columns, and the expression-columns to the left, which makes them rows.

Re: Report Format

marcus_sommer — Wed, 02 Sep 2015 10:32:01 GMT

If you want to mix dimension and expression within the horizontally then you need to replace the horizontal-dimension through expressions like:

sum({< Week = {27}>} value)

or depending on selections or today:

sum({< Week = {"$(=max(Week) -8)"}>} value)

sum({< Week = {"$(=max(week(today()) -8)"}>} value)

- Marcus

Re: Report Format

Anonymous — Wed, 02 Sep 2015 10:44:53 GMT

tried but that dont work.

Thanks