topic Set Analysis? in QlikView

Set Analysis?

Anonymous — Fri, 30 Jul 2010 16:23:27 GMT

My raw data included a total row & looks like below:

Overall Jan 10

Producta Jan 5

Productb Jan 2

Overall Feb 100

Producta Feb 4

I need to create report like below:

Producta Jan 50%

Productb Jan 20%

Producta Feb 4%

How can I do that?

Thanks,

Dinesh.

Set Analysis?

Fri, 30 Jul 2010 16:53:53 GMT

You have lame structure. You can remove all pre-aggregated totals (Overall), then your expression will looks like this:

sum(Value)/sum(total <Month> Value)

If you still want use Overalls then you need to duplicate it for each appropriate product per month like this:

ProductName Month Value Overall

Producta Jan 5 10

Productb Jan 2 10

Producta Feb 4 100

The expression will look like this:

sum(Value)/Overall

But it is lame approach as well. Use the first one.

See example in attachment.

Set Analysis?

Anonymous — Fri, 30 Jul 2010 17:46:55 GMT

I need to create a market share report in which I have the information about our company & the industry total (overall), but not the information about the competition which makes up the overall number. In other words, I need to use the overall #.

The trouble with duplication would be in cases when in a particular month, our company did not sell anything, but there is an overall #.

On a related note, I am using a personal edition & I cant open your attachment. Would appreciate if you could explain in text what you wanted to show in the attachment.

Thanks,

Dinesh.

Set Analysis?

Fri, 30 Jul 2010 18:09:05 GMT

You should have Industry Overall as lookup table then:

The data will look like this:

The Expression is:

for many Overalls per month

sum(Value)/sum(Overall)

or if your are sure that the data for Overall will be just one value per month, then:

sum(Value)/only(Overall)

See updated attachment.