how to get Measure Values as in Qliksense

[lakshman1031]

Hi All,

I have Measures like Score. in that values having 1,2,3,4,5 like that.

I created on Master dimension and i am taking as filter.

If i select 1 then it will select 2and 3 also.

I want to see if i select 1 then reflected 1 only.

can you please suggest me how to get the excepted output when i select filter.

Thanks & Regards,

Lakshman

[mpc]

Hi, 

For this specific case (dim = 1) you can use min(score).
But, if you selection is dim = 2, what's displayed and what's the desired output ? 

Best

[lakshman1031]

Hi ,

Thank you for your replay.

I have Master dimension values like 1,2,3,4,5,6 like that,

If i select 1 then show the 1 and if i select 2 then show 2 related values like that.

but if i select 2 then show 1,2,3 values like that how to get only one value like if i select 1, then show 1 and if i select 2 then show 2 like that 

I am using formula like

Aggr(Count(Subjects),Site)+Aggr(Count(Categories),Site)

The above expression is used to create Master dimension and i have used this master dimension as filter.

Aggr(Count(Subjects),Site) this expression having values are 1,2,3 and 

Aggr(Count(Categories),Site) this expression having values are 4,5,6

I added this master dimension as filter and now my values are 1,2,3,4,5,6

If i select 2 then it will shows 1,2,3 and if i select 4 then 4,5,6 values will shows.

I want to show if i select 2 the shows 2 only , and if i select 6 then shows 6 only. it won't reflected other data.

can you please suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman

[Kushal_Chawda]

@lakshman1031  Don't understand your requirement entirely. When you use Aggr(Count(Subjects),Site)  and select the value 1, it will select value 1 but selection actually will be performed on Site because you are aggregating it by Site. are your Site values like 1,2,3? then it should be fine. Please share some screenshots of what you are doing and what is expected.

[lakshman1031]

Hi Kushal,

I have Measure and I didn't have direct filed for filtering the data.

I have combined 5 expressions and each expression having 1,2,3

and combined all expression into single expression. now i am getting 6,7,8,9,10,11,12,13 these are the values.

the entire expression is created one master dimension and i have take one filter and take master dimension as filter.

can you please see the expression for reference.

If i select 6 then it will show 6,7,8 and if i select 8 then 8,9,10 and if i select 11 then 11,12,13

if i select any one value then it will reflected 3 values at a time.

My Requirement is if i select 6 then show 6 , if i select 7 then show 7 if i select 8 then show 8 like that.

=Aggr((

if(sum(subjects_enrolled)>=Mean_IRT,'1',if(sum(subjects_enrolled)<if(len(Median_IRT)=0,Aggr($(vMaxMedianIRT),ISN),Max(Median_IRT)),'3','2'))
+
if(count({<any_aecoded_value = {'1'},ae_serious_desc = {'YES'}>} any_aecoded_value)>=mean_sae,'3',
if(count({<any_aecoded_value = {'1'},ae_serious_desc = {'YES'}>} any_aecoded_value)<if(len(median_sae)=0,Aggr($(vMaxMedianSAE),ISN),Max(median_sae)),'1','2'))
+
if(sum(screen_failure_rate)>=Mean_Screen_Failure_Rate,'3',if(sum(screen_failure_rate)<
if(len(Median_Screen_Failure_Rate)=0,Aggr($(vMaxMedianScreenFailure),ISN),Max(Median_Screen_Failure_Rate)),'1','2'))
+
if(Count({<any_aecoded_value = {'1'}>}any_aecoded_value)>=Mean_rave,'3',if(Count({<any_aecoded_value = {'1'}>}any_aecoded_value)<if(len(Median_rava)=0,Aggr($(vMaxMedianAE),ISN),Max(Median_rava)),'1','2'))
+
if(Count(Deviation_ID)>=Mean_Protocal,'3',if(Count(Deviation_ID)< if(len(Median_Protocal)=0,Aggr($(vMaxMedianProtocol),ISN),Max(Median_Protocal)),'1','2'

))),

site)

Can you please suggest me how to do this scenario.

Thanks & Regards,

Lakshman

[Kushal_Chawda]

@lakshman1031  It will be tough to see the problem and provide solution with this explanation. Probably sample app with dummy data will be helpful

[lakshman1031]

Hi Kushal,

I have created on bar chart and in that i have created Measure. 

=Aggr((

if(sum(subjects_enrolled)>=Mean_IRT,'1',if(sum(subjects_enrolled)<if(len(Median_IRT)=0,Aggr($(vMaxMedianIRT),ISN),Max(Median_IRT)),'3','2')),site)

Based on the above expression in my bar chart showing 1,2,3.

I want to show same values in bar chart also. this is not a direct dimension in backend side, that's what i created one master dimension.

I have take one filter and mention master dimension in filter then i am able to see values like 1,2,3.

now if i select 1 in filter then it will work properly, and if i select 2 then it will shows 2 and 3 at a time.

Can you please suggest me how to handle filter selection in Master dimension filter.

Thanks & Regards,

Lakshman