topic Re: Can help me in QlikView

Can help me

santharubban — Fri, 11 Apr 2014 16:14:01 GMT

I have two Pivot tables one table is Taxonomy service and the other is Thershold please find in attachement.

Thershold value in taxonomy table should same for all months for Primary care taxonomy service similar for all service.

Primary care thershold value = 0.12

but Primary care thershold value in Taxonomy table value different value for each month.Its shouyld be same for all months.

Experssion here:

num(

(num((COUNT({1<NOT_IN_FR = {0},RPT_MON = P({<RPT_MON =,Month=,YEAR=,DOS=>} DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} DISTINCT ENCOUNTER_KEY)/

Count({1<SUBMITTER_ID = ,RPT_MON = P({<RPT_MON =,Month=,DOS=,YEAR=>} DOS),TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>}IPA_MEMBER_ID)),'#,##0.##')*12),'#,##0.##')

Re: Can help me

Fri, 11 Apr 2014 16:20:11 GMT

Did you try TOTAL statement in your second expression.?

Re: Can help me

santharubban — Fri, 11 Apr 2014 16:23:08 GMT

can tell where to use total ?

Re: Can help me

Fri, 11 Apr 2014 16:27:18 GMT

Re: Can help me

Fri, 11 Apr 2014 16:30:52 GMT

use aggr function with your month or date field.

Re: Can help me

santharubban — Fri, 11 Apr 2014 16:51:26 GMT

it didn't work..

Re: Can help me

santharubban — Fri, 11 Apr 2014 16:51:36 GMT

it didn't work..

Re: Can help me

santharubban — Fri, 11 Apr 2014 17:04:04 GMT

can anyone help me

Re: Can help me

Fri, 11 Apr 2014 17:18:11 GMT

I haven't tried this but you just need to know where the TOTAL should be placed. TOTAL tells the expression to ignore the dimension/s similar to how {1} tells the expression to ignore selections.

Try this - (also use TOTAL for the numerator)

num(

(num((COUNT({1<NOT_IN_FR = {0},RPT_MON = P({<RPT_MON =,Month=,YEAR=,DOS=>} DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} TOTAL DISTINCT ENCOUNTER_KEY)/

Count({1<SUBMITTER_ID = ,RPT_MON = P({<RPT_MON =,Month=,DOS=,YEAR=>} DOS),TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} TOTAL IPA_MEMBER_ID)),'#,##0.##')*12),'#,##0.##')

Re: Can help me

santharubban — Fri, 11 Apr 2014 17:25:11 GMT

I try the above expression,but it didn't work. I am getting total of all taxonomy services.

Re: Can help me

Fri, 11 Apr 2014 17:31:41 GMT

since TOTAL ignores dimensions, to consider specific dimensions use:

TOTAL <dimension1, dimension2>

in your case try - TOTAL <'Taxonomy Group'>

num(

(num((COUNT({1<NOT_IN_FR = {0},RPT_MON = P({<RPT_MON =,Month=,YEAR=,DOS=>} DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} TOTAL <TAXONOMY_GROUP> DISTINCT ENCOUNTER_KEY)/

Count({1<SUBMITTER_ID = ,RPT_MON = P({<RPT_MON =,Month=,DOS=,YEAR=>} DOS),TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} TOTAL <TAXONOMY_GROUP> IPA_MEMBER_ID)),'#,##0.##')*12),'#,##0.##')

Re: Can help me

santharubban — Fri, 11 Apr 2014 19:27:59 GMT

Thanks Patrick....