topic Re: Set analysis in QlikView

Set analysis

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

Hi All ,

How to write this with set analysis expression.

if(dealstate_id=8 or dealstate_id=9 or dealstate_id=33 or dealstate_id=34 or dealstate_id=71,UPPER(customerFirstName)&' '&UPPER(customerSurname) )

Thanks,

jyothish8807 — Fri, 27 Jul 2018 06:29:07 GMT

Try this:

maxstring({<dealstate_id={'8','9','33','34','71'}>}UPPER(customerFirstName)&' '&UPPER(customerSurname))

Br,

sunny_talwar — Fri, 27 Jul 2018 11:22:20 GMT

You can also try this

Upper(Only({<dealstate_id = {8, 9, 33, 34, 71}>} customerFirstName & ' ' & customerSurname))

suvechha_b — Fri, 27 Jul 2018 12:11:44 GMT

Hi Sunny ,

I have tried your its coming error .

I have used the below one in dimension . I am not sure is it the correct way of doing according to performance .of pivot table .

=if(dealstate_id=8 or dealstate_id=9 or dealstate_id=33 or dealstate_id=34 or dealstate_id=71,UPPER(salesperson)) .

it is working but my pivot table is slow that why I am trying of different set analysis.

Thanks

sunny_talwar — Fri, 27 Jul 2018 12:15:40 GMT

Use this in your set analysis for your expression

{<dealstate_id = {8, 9, 33, 34, 71}>}

and create a new field in the script

Upper(customerFirstName & ' ' & customerSurname) as Customer_Full_Name

and use Customer_Full_Name as your dimension