How to get values first & maximum values in qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to get values first & maximum values in qlikview

Anonymous — Wed, 20 Jun 2018 16:17:19 GMT

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: