topic Re: how to make Variable static ? in QlikView

how to make Variable static ?

santharubban — Thu, 03 Apr 2014 17:57:37 GMT

Variable value shouldn't change when i select any filiters in app. This variable is derived expression.

Re: how to make Variable static ?

Nicole-Smith — Thu, 03 Apr 2014 18:00:27 GMT

If you want your variable to be sum(Field), when you define it, define it as =sum({1}Field). Then it should always have the total sum, not affected by selections.

Re: how to make Variable static ?

swuehl — Thu, 03 Apr 2014 18:00:52 GMT

How does your variable definition looks like?

Re: how to make Variable static ?

MK_QSL — Thu, 03 Apr 2014 18:03:03 GMT

You can lock it by {1} or ALL

i.e. Count({1}Customer)

SUM(ALL Sales)

Re: how to make Variable static ?

santharubban — Thu, 03 Apr 2014 20:01:03 GMT

Hi all Thanks for your replys...

but it doesn't work. I have uploaded my variable value below

({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,MONTH= >} DISTINCT ENCOUNTER_KEY)

Re: how to make Variable static ?

santharubban — Thu, 03 Apr 2014 20:52:15 GMT

can anyone help me

Re: how to make Variable static ?

Thu, 03 Apr 2014 21:18:14 GMT

what value of your variable you expect when there is nothing selected? Doests it work then? You want to have part of expression in this variable or result of expression? For me it looks like part of expression ...

Try to write your expression in chart without using this variable. Does it work?

Re: how to make Variable static ?

MK_QSL — Fri, 04 Apr 2014 05:46:44 GMT

Try

SUM(({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =,IPA_Type=,YEAR=,MONTH= >} DISTINCT ENCOUNTER_KEY))

COUNT(({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =,IPA_Type=,YEAR=,MONTH= >} DISTINCT ENCOUNTER_KEY))

AVG(({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =,IPA_Type=,YEAR=,MONTH= >} DISTINCT ENCOUNTER_KEY))

Re: how to make Variable static ?

santharubban — Fri, 04 Apr 2014 13:16:50 GMT

Hi all,

plesae find the full expression,

num(((COUNT({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,MONTH =,RPT_MON= >} DISTINCT ENCOUNTER_KEY)/
Count({1<SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,MONTH =,RPT_MON=>}IPA_MEMBER_ID))*12),'#,##0.##')

This variable value shouldn't change, when i select the filiter. It should be a static value, but when i select month the value is changing.

Re: how to make Variable static ?

Fri, 04 Apr 2014 13:20:12 GMT

Isn't it p(DOS) associated with Month?

Try maybe something like

p({<Month=>DOS})

Look if after selections of Month possible DOS value list changes...

regards

Darek

Re: how to make Variable static ?

santharubban — Fri, 04 Apr 2014 13:35:54 GMT

thanks Darek....

Its not working.

Re: how to make Variable static ?

Fri, 04 Apr 2014 13:40:37 GMT

Maybe you have some other field not used in set <NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,MONTH =,RPT_MON= >, which is sensitive to month selection?

How is IPA_MEMBER_ID connected to month?

May you provide script with some test data or sample app to let us have a closer look on it?

regards

Darek

Re: how to make Variable static ?

santharubban — Fri, 04 Apr 2014 13:44:11 GMT

Thanks for quick reply..

please find the datamodel attached

Re: Re: how to make Variable static ?

Fri, 04 Apr 2014 13:49:10 GMT

Anyway please take a look for my sample.

I still think, that P() is a reason...

Re: how to make Variable static ?

Fri, 04 Apr 2014 13:52:53 GMT

I think you should try to change:

p(DOS)

for:

p({<MONTH=>}DOS)

Re: how to make Variable static ?

santharubban — Fri, 04 Apr 2014 17:30:21 GMT

Hi ,

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)

Correct :

RPT_MON = P({<RPT_MON =,Month=,YEAR=,DOS=>} DOS ) tby this part achieve my requirement

Thanks for Dariusz Mielczarek ,let helped me a lot...