Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Hi,

Here Iam Attaching qvw file.

which may help u ....

View solution in original post

2 Replies
Not applicable
Author

Hi,

Here Iam Attaching qvw file.

which may help u ....

Not applicable
Author

Hi

Thank you so much .

I cannot believe how simple the final formula was.

Regards

Ania