Frequency Distribution by groups

Mon, 09 May 2011 09:29:19 GMT

Hi there

I'm fairly new to Qlikview and I have looked through the various discussions and none seem to help me in terms of what I would like to do. I have just recently learnt how to import the data and do the multiple links across fields but now I'm in the process of displaying the value add and the power of BI.

The data I would like to see in table format is as follows:

Year	Band	Freq	Freq %
2008	A	20	20 %
2008	B	80	80 %
2009	A	30	30 %
2009	B	70	70 %

I can get the frequency (3rd column) using count(Field) but the percentages I am struggling with as they need to be by year and band totals. I believe I may need to use set analysis here, but I don't know how to go about it.

I would then like to display the Freq % in a multiple bar graph by band (x-axis) and freq % (y-axis) split by the various years (Bars).

I'd really appreciate if someone could guide me through this process as the learning curve is fairly tough to get through.

In advance I'd like to say thanks for the help.

Regards

Ania

Re: Frequency Distribution by groups

Wed, 11 May 2011 09:22:19 GMT

Hi,

Here Iam Attaching qvw file.

which may help u ....

Re: Frequency Distribution by groups

Wed, 11 May 2011 12:56:02 GMT

Thank you so much .

I cannot believe how simple the final formula was.

Regards

Ania

topic Re: Frequency Distribution by groups in QlikView

Frequency Distribution by groups

Re: Frequency Distribution by groups

Re: Frequency Distribution by groups