Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Frequency Distribution by groups

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:

YearBandFreqFreq %
2008A2020 %
2008B8080 %
2009A3030 %
2009B7070 %


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

1 Solution

Accepted Solutions
Not applicable

Re: Frequency Distribution by groups

Hi,

Here Iam Attaching qvw file.

which may help u ....

2 Replies
Not applicable

Re: Frequency Distribution by groups

Hi,

Here Iam Attaching qvw file.

which may help u ....

Not applicable

Re: Frequency Distribution by groups

Hi

Thank you so much .

I cannot believe how simple the final formula was.

Regards

Ania

Community Browser