Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Autonumber and Group by clause

Hi,

I have a table with subscriptions, transactions and transaction types. Subscriptions are comprised of transactions of various transaction types. For each subscription I would like to create a counter on a transaction level to track the number of certain transaction types that the subscription has made. I'm able to use the autonumber function to do this, however, unable to limit it to only numerate transactions with a specific subscription. Ideally, I would group by subscriptions, then by transactions in ascending order and assign a number to each transaction which meets specific conditions.

Explanation may sound confusing so I've attached an example to work with.

I think I'm pretty close to getting this to work, so if anyone has the time to give it a look it would be much appreciated.

Best,

Matt

Tags (4)
1 Solution

Accepted Solutions
Highlighted
somenathroy
Contributor III

Re: Autonumber and Group by clause

The link below may address your solution.

http://community.qlik.com/message/277287#277287

Regards,

Som

View solution in original post

5 Replies
Highlighted
Not applicable

Re: Autonumber and Group by clause

Hi,

If you want to limit the records, use a straight table chart and specify your limit on Dimension Limits tab.

Regards,

Janzen

Highlighted
Not applicable

Re: Autonumber and Group by clause

Thanks Janzen,

That's not exactly what I need.

I want to group subscriptions and then tranancations and assign a number in asending order to each transaction in the subscription.

Hopefully that's clearer. I aso have an example attached.

Best,

Matt

Highlighted
somenathroy
Contributor III

Re: Autonumber and Group by clause

The link below may address your solution.

http://community.qlik.com/message/277287#277287

Regards,

Som

View solution in original post

Highlighted
Not applicable

Re: Autonumber and Group by clause

Hai,

Som has given the correct link.

Thanks

Highlighted
Not applicable

Re: Autonumber and Group by clause

Thanks for the help!

I should be able to use this for what I'm doing. If I have an issue I may need to ask another question.

Thanks again.

Matt