Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Not applicable

How to Summarize in Qlikview?

Hello,

I was wondering how I could summarize on unique identifiers and get that count to show in a graph.

For example, I have 5 different accounts. Each account is listed multiple times in the data. I want a bar graph that will have a bar for each account (5 bars) representing the account on the X-Axis, with the Y-Axis reflecting the number of times each account appears (count).

Does anyone know the correct code syntax to accomplish this?

Thanks in advance,

Ryan

Tags (1)
2 Replies
MVP
MVP

Re: How to Summarize in Qlikview?

i thinh you have already answer

dimension      Account

expression     count (somefield)

Re: How to Summarize in Qlikview?

Use the accounts field as dimension and count(AccountsField) as expression. Replace AccountsField with the real name of your accounts field.


talk is cheap, supply exceeds demand
Community Browser