topic Re: two conditions in dimensions in QlikView

two conditions in dimensions

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

Hi Qlikview Gurus,

Please help its urgent.

I have the following Requirement where the data is

CUSTNUM SEQ VALUE NAME

1 2 PRCT A

1 1 CTR e

1 3 CTOR d

1 4 PRCT B

I need to check two conditions

1) Value=PRCT 2) Max(SEQ) and then display the Custname for this CUSTNUM

Eg:-Here in this example if i select custnum then Name should display B,Because if we apply the

if(Value='PRCT',Name) then we will have only 2 rows but how do I take the max of SEQ and display B.

Please help its urgent.

Re: two conditions in dimensions

sunny_talwar — Thu, 15 Sep 2016 21:19:42 GMT

May be like this:

FirstSortedValue({<VALUE = {'PRCT'}>} NAME, -SEQ)

Re: two conditions in dimensions

sunny_talwar — Thu, 15 Sep 2016 21:25:41 GMT

Check out the attachment

Re: two conditions in dimensions

Anonymous — Thu, 15 Sep 2016 21:40:46 GMT

Sunny I cant open as I have personal edition.

Can you please write the code here or its the same which you have written ?

Will this code work if we have more than 1 CUSTNUM as we need to group it by CUSTNUM also then...

Please correct me if I am wrong.

Re: two conditions in dimensions

Thu, 15 Sep 2016 21:47:25 GMT

hi sunny. wh verson qlikview , r u using? ur qvw not opening in my qlikview. I am using qlikview 12 ,64 bit trial version.

any solution for it.

Re: two conditions in dimensions

sunny_talwar — Thu, 15 Sep 2016 21:53:23 GMT

I am using QV12 SR5 I think

Re: two conditions in dimensions

sunny_talwar — Thu, 15 Sep 2016 21:54:42 GMT

There are two options

1) Create a straight table

Dimension

CUSTNUM

Expression

FirstSortedValue({<VALUE = {'PRCT'}>} NAME, -SEQ)

2) Concat them in a text box object

Concat(DISTINCT Aggr(FirstSortedValue({<VALUE = {'PRCT'}>} NAME, -SEQ), CUSTNUM))

Re: two conditions in dimensions

Digvijay_Singh — Fri, 16 Sep 2016 04:07:16 GMT

Without license you cannot open others qvw files.

Re: two conditions in dimensions

Anonymous — Fri, 16 Sep 2016 12:33:07 GMT

Thank you Sunny very much for your help.

Really appreciate the quick solution.