Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

igdrazil
Contributor III

First Sorted Value

Hi There,

can someone tell my why my First Sorted Value function isn't working?

Please find attached .qvf

Regards

Chris

1 Solution

Accepted Solutions

Re: First Sorted Value

Check the screenshot out:

Capture.PNG

1) You need to change the formatting to 'Custom'.

2) Your Word1, Value1 has two Min(Value1), I don't know which one you wanted to see, but using DISTINCT would show you one of them.

HTH

Best,

Sunny

3 Replies

Re: First Sorted Value

Check the screenshot out:

Capture.PNG

1) You need to change the formatting to 'Custom'.

2) Your Word1, Value1 has two Min(Value1), I don't know which one you wanted to see, but using DISTINCT would show you one of them.

HTH

Best,

Sunny

igdrazil
Contributor III

Re: First Sorted Value

Yes i know that i had 2 values for that, i was just testing the functionality of it. so i took word2 and value2 without duplicates and had the same problem. That is why i was wondering what the problem could be. So the formatting was the problem!

Thank you


Regards

Chris

Re: First Sorted Value

Yup

Community Browser