topic For one dimension, show the first row only in QlikView

For one dimension, show the first row only

Tue, 15 Jul 2014 14:48:40 GMT

In a Pivot Table, I have a calculated dimension 'Client Name'. I have another dimension Year Month.

For each Client Name, I would like to filter on the first row for Year Month. In other words, I would like to keep only the first date (Year-Month) for each Client Name.

For example, in the table above, I would to keep 2011-07 for the first client name, 2011-10 for the second client name, 2011-12 for the third, 2012-06 for the fourth etc... All other rows should be filtered out, namely 2013-06 for the second client name, etc...

Which approach would you suggest?

Thanks in advance

Re: For one dimension, show the first row only

Tue, 15 Jul 2014 15:14:06 GMT

I don't think this is posible in a pivot table without making the a precalculation in the script which returns only 1 value.

Other option might be changing this to a straight table. Here you have 2 options of dimension limiting:

Use Dimension limits (3rd tap in object properties)
Use Max Value = 1 in presentation tab and sort on latest yearmonth

Re: For one dimension, show the first row only

Wed, 16 Jul 2014 10:41:07 GMT

Thanks a lot, I am trying the solution with the straight table.

1. For which dimension should I set limits? I struggle to find how to use the limits.

2. I set MaxValue to 1, and this basically shrink my table to the first row for account.... I would like to keep ALL Account, but display only one row for transaction per account.

Thanks in advance.

Re: For one dimension, show the first row only

Wed, 16 Jul 2014 11:12:56 GMT

Ah I see. I think its posible with the first option.

Could you upload the qvw?

Re: For one dimension, show the first row only

Wed, 16 Jul 2014 11:42:03 GMT

Thanks for your reply.

Actually, I cannot. could you elaborate on your idea?