topic Re: Conditional Dimension in QlikView

Conditional Dimension

cbaqir — Sat, 16 Nov 2024 04:00:24 GMT

I have a dimension called DOMAIN. There are two possibilities, ECISA and CAREB.

If the dimension called DESCRIPTION and the LAST_REVIEWED_DATE are the same, I want the DOMAIN to show as A/B instead of one line for ECISA and one line for CAREB.

For example: DESCRIPTION = NICU (Neonatal) Admission

If the dimension called DESCRIPTION and the LAST_REVIEWED_DATE are NOT the same, I want the DOMAIN on one line for ECISA and one line for CAREB.

For example, DESCRIPTION = Heparin Infusion for ACS/Vascular (Xa)

Can someone please help me?

Re: Conditional Dimension

Anil_Babu_Samineni — Mon, 01 Apr 2019 11:17:13 GMT

Perhaps this?

sum(aggr(Sum({$<DOMAIN = {'A'}>}USAGE),DOMAIN,GOVERNING_CCG,DESCRIPTION,LAST_REVIEW_DATE))/sum(aggr(Sum({$<DOMAIN = {'B'}>}USAGE),DOMAIN,GOVERNING_CCG,DESCRIPTION,LAST_REVIEW_DATE))

Re: Conditional Dimension

cbaqir — Mon, 01 Apr 2019 14:12:09 GMT

I am not sure why there is "/" nor the sum function. Can you help me understand?

Re: Conditional Dimension

cbaqir — Mon, 01 Apr 2019 20:17:07 GMT

@sunny_talwar Any idea?

Re: Conditional Dimension

sunny_talwar — Mon, 01 Apr 2019 20:34:30 GMT

Try this

=Aggr(If(Count(TOTAL <DESCRIPTION> DOMAIN)>1 and Count(DISTINCT TOTAL <DESCRIPTION> LAST_REVIEW_DATE) = 1,'A/B',DOMAIN), DESCRIPTION, DOMAIN)

Re: Conditional Dimension

cbaqir — Mon, 01 Apr 2019 20:37:05 GMT

OMG THANK YOU!!!