topic Re: Autonumber and Group by clause in QlikView

Autonumber and Group by clause

Thu, 08 Nov 2012 22:21:39 GMT

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

Re: Autonumber and Group by clause

Fri, 09 Nov 2012 01:59:15 GMT

Hi,

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

Regards,

Janzen

Re: Autonumber and Group by clause

Fri, 09 Nov 2012 03:58:09 GMT

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

Re: Autonumber and Group by clause

somenathroy — Fri, 09 Nov 2012 05:50:58 GMT

The link below may address your solution.

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

Regards,

Som

Re: Autonumber and Group by clause

Fri, 09 Nov 2012 06:07:58 GMT

Hai,

Som has given the correct link.

Thanks

Re: Autonumber and Group by clause

Mon, 12 Nov 2012 21:08:09 GMT

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