topic Re: Firstsorted value in QlikView

Firstsorted value

Anonymous — Mon, 11 Sep 2017 16:32:48 GMT

4 numbers are blocking each date and days also same but i want output below one

654582-002,729871-001, 773911-002, 777321-001 in script level for each distinct date like output

Anil_Babu_Samineni — Mon, 11 Sep 2017 16:34:23 GMT

sunny_talwar — Mon, 11 Sep 2017 16:38:17 GMT

May be like this

Fact:

LOAD Date,

product,

[max days],

Concat(DISTINCT Number, ', ') as Number

FROM....

Group By Date, product, [max days];

its_anandrjs — Mon, 11 Sep 2017 16:49:14 GMT

If on the UI part you required this than try this ways

Dim:- Date, product, max days

Expre:- Concat(DISTINCT Number, ', ')

Anonymous — Wed, 13 Sep 2017 10:44:28 GMT

Hi Experts,

How to use first sorted value in Script level ? Can any one Explain me with Example?

Anonymous — Wed, 13 Sep 2017 10:44:51 GMT

How to use first sorted value in Script level ? Can any one Explain me with Example?

Kushal_Chawda — Wed, 13 Sep 2017 10:46:50 GMT

I think you are asking the question which is not in a context with your requirement.

sunny_talwar — Wed, 13 Sep 2017 11:22:45 GMT

Where did firstsortedvalue came in from? May be check here:

its_anandrjs — Wed, 13 Sep 2017 12:25:50 GMT

In this model or data model and the output that you need is not using Firstsorted

Check about Firstsorted example