How to get values first & maximum values in qlikview

[Anonymous]

Hi experts.

Give me a solution of given example

my table is like this

unique,doc

123,(343,241)

122,(243,546)

Now I want output like this(i,e.In first output is 1st value doc & in second output is maximum value of doc).

first value          maximum value

343                    343

243                     546

In different  outputs.

thanks in advance.

[Anonymous]

Hello, sumanyedla121

You can do something like this in script:

Load unique,

        SubField(PurgeChar(doc, '()'), ',', 1) As [First Value],

        SubField(PurgeChar(doc, '()'), ',') As Values;

Data:

Load * Inline

[unique,doc

123,"(343,241)"

122,"(243,546)"

];

After that, you can create your table like this:

Dimension: "unique"

Expressions:

=[First Value]

=Max(Values)

You can also hide the "unique" column on Presentation tab -> Hide Column

I ended up with this table: