topic Re: Straight table multiple dimensions in QlikView

Straight table multiple dimensions

Thu, 05 Dec 2013 05:42:59 GMT

Eligibility : A member who is Eligible for a Program

Enrolled: A member who is Enrolled in a Program.

For Eligibility i calculate the Gender Classification based on :

Dimension:

=If(MEM_GENDER='M','Male',IF(MEM_GENDER='F','Female','Unknown'))

Expression

= COUNT(DISTINCT PERSON_KEY)

For Enrolled i calculate the Gender Classification based on :

Dimension:

=If(ELIG_PERS_GENDR_CD='M','Male',IF(ELIG_PERS_GENDR_CD='F','Female','Unknown'))

Expression

= COUNT(DISTINCT ELIG_PERSON_KEY)

How can i bring these two dimensions under a single straight table as i have to calculate the Eligible/Enrolled percentage for

Gender group.There are two dimensions and two expressions which i have to get them under a single chart?

any ideas?

Re: Straight table multiple dimensions

jagan — Thu, 05 Dec 2013 06:06:02 GMT

Hi,

Can you attach sample data and file?

Regards,

Jagan.

Re: Straight table multiple dimensions

Thu, 05 Dec 2013 06:07:39 GMT

Hi Poornima

PFA.... Hope it will give you some idea

Regards

nirmal

Re: Straight table multiple dimensions

Thu, 05 Dec 2013 06:16:48 GMT

Hi Nirmal,

The gender columns are also different in my case: MEM_GENDER,ELIG_PERS_GENDR_CD

How will i specify as two dimensions and which one to map for the expressions?

Re: Straight table multiple dimensions

kaushiknsolanki — Thu, 05 Dec 2013 06:17:40 GMT

Hi,

It will depend on the way the data model is designed.

One thing need to know why do we have 2 different columns for Gender? Why cant we just combine it.

If we combine this, you will get the solution.

Regards,

Kaushik Solanki

Re: Straight table multiple dimensions

Thu, 05 Dec 2013 06:19:22 GMT

can you please attach your application... hope it will easy to do

Both gender field names are different ok but in that field values are same correct???

Re: Straight table multiple dimensions

Thu, 05 Dec 2013 06:32:30 GMT

They are two different tables .So

they are not linked in any way

Re: Straight table multiple dimensions

Thu, 05 Dec 2013 06:34:13 GMT

ok attach your sample application

Re: Straight table multiple dimensions

kaushiknsolanki — Thu, 05 Dec 2013 06:40:01 GMT

Hi,

Then you need to link them together anyhow to make them available under one chart.

Regards,

Kaushik Solanki

Re: Re: Straight table multiple dimensions

Thu, 05 Dec 2013 06:40:46 GMT

PFA sample application

Re: Re: Re: Straight table multiple dimensions

Thu, 05 Dec 2013 06:47:39 GMT

PFA... Please reload this application and let me know.... hope it will help you

Re: Straight table multiple dimensions

Anonymous — Thu, 05 Dec 2013 06:51:20 GMT

Hi Poornima,

First of All make a inline load as

Load * inline

[

Gender

Male

Female

Unknown

];

Then Create a chart having dimension as Gender and two Expressions as follows:

Eligible>>

if(Gender='Male', COUNT(DISTINCT{ $<MEM_GENDER={'M'}>} PERSON_KEY),

if(Gender='Female',COUNT(DISTINCT{ $<MEM_GENDER={'F'}>} PERSON_KEY),

COUNT(DISTINCT{ $<MEM_GENDER={'*'}-{'M','F'}>} PERSON_KEY))

)

Enrolled>>

if(Gender='Male', COUNT(DISTINCT{ $<ELIG_PERS_GENDR_CD={'M'}>} ELIG_PERSON_KEY),

if(Gender='Female',COUNT(DISTINCT{ $<ELIG_PERS_GENDR_CD={'F'}>} ELIG_PERSON_KEY),

COUNT(DISTINCT{ $<ELIG_PERS_GENDR_CD={'*'}-{'M','F'}>} ELIG_PERSON_KEY)))

)

As I have directly written the expressions here , there may be any syntax error, anyway logic will be same.

Hope it helps you

Regards

Nitin Gupta

Re: Straight table multiple dimensions

kaushiknsolanki — Thu, 05 Dec 2013 06:57:22 GMT

Hi,

Try this Calculated Expression.

=If(MEM_GENDER='M' and ELIG_PERS_GENDR_CD='M','Male',IF(MEM_GENDER='F' and ELIG_PERS_GENDR_CD='F','Female'))

Regards,

Kaushik Solanki