topic Re: Displaying a value based on another value in a table in QlikView

Displaying a value based on another value in a table

julesjohnson — Thu, 30 Mar 2017 08:12:05 GMT

I have a table that looks something like this. In some cases there are multiple cost centers for one phone number. In these cases, I would like to write an expression that will only show the cost center associated with the status "in Use". In my example below, that would be cost center 879090.

Is this possible?

Number	Status	Center
555-555-1711	In Use	879090
555-555-1711	Closed	909840
555-555-1711	Pending	90876544
555-555-1712	In Use	3788909

Thanks,

Re: Displaying a value based on another value in a table

sunny_talwar — Thu, 30 Mar 2017 08:16:03 GMT

May be like this

Dimension

Number

Expression

If(Count(Number) > 1, Only({<Status = {'In Use'}>} Center), Only(Center))

Re: Displaying a value based on another value in a table

karthiksrqv — Thu, 30 Mar 2017 08:24:58 GMT

Hi,

With the phone number as the dimension, you could use

Concat(Distinct {<Status={"In Use"}>} Center)

Re: Displaying a value based on another value in a table

julesjohnson — Thu, 30 Mar 2017 08:28:06 GMT

Hi Sunny,

I tweaked it just a bit to fit my actual column names it it worked perfectly!!

if(count(DISTINCT [Cost Center])>1, Only({<Status = {'In Use'}>} [Cost Center]), Only([Cost Center]))

Thanks so much