topic set analisys help in QlikView

set analisys help

gidon500 — Tue, 16 Sep 2014 14:33:27 GMT

Hi guy

Enclosed is a data file

and qvw file

it includes sales and targets for sales agent

i need to show the target for the agent , with year and quarter are selected

(according to the selection of the data

year and quarter of sales )

i tried several set analisys formulas with sucsses

hope you can help

thanks

gidon

anbu1984 — Tue, 16 Sep 2014 14:44:04 GMT

Problem is association didn't happen on Quarter and Year. Try this

TARGET:

LOAD Agent,

[T-QTR] As Quarter,

[T-Year] As Year,

Target

FROM

(ooxml, embedded labels, table is data);

gidon500 — Tue, 16 Sep 2014 14:50:44 GMT

Hi Anbu

Since I have more data and dimentions to add

I cannot use this statment

can you help by using set analisys in the object

gidon

maxgro — Tue, 16 Sep 2014 15:07:06 GMT

maybe thie

sum({$ <[T-Year]=P(Year),[T-QTR]=P(Quarter)>} Target)

but I think you should change your db model (example 1 fact table and 1 calendar)

anbu1984 — Tue, 16 Sep 2014 15:08:32 GMT

In Set analysis,

=sum({<[T-Year]={$(=GetFieldSelections(Year))},[T-QTR]={$(=GetFieldSelections(Quarter))}>}Target)

gidon500 — Tue, 16 Sep 2014 15:56:20 GMT

Hi Anbu

it seems working

thanks

gidon