topic Re: Find Max Value for two selected value in QlikView

Find Max Value for two selected value

Thu, 18 Sep 2014 15:01:36 GMT

Hi friends,

I am attaching my application,where I want to view the Max value for two selected interval,if anyone get any idea please fix this its really urgent.

Regards

Bhawna

Re: Find Max Value for two selected value

MK_QSL — Thu, 18 Sep 2014 15:05:47 GMT

Can you provide little more idea about your requirements?

Re: Find Max Value for two selected value

juleshartley — Thu, 18 Sep 2014 15:12:35 GMT

First comment that I'd make is that your data model looks a bit odd. What is the point of the 'Value', 'Value 1' etc. fields?

I would 'crosstable' the data so that you have 'interval' as a field with values 1-3 Month etc. And then a single 'Value' field.

ie.

Product Interval Value

P1 1-3 Month 200

P2 1-3 Month 500

P1 4-6 Month 300

Then your calculations are a lot easier.

Re: Find Max Value for two selected value

rubenmarin — Thu, 18 Sep 2014 15:16:02 GMT

you searching for?:

=MaxString(Interval)

Re: Find Max Value for two selected value

Thu, 18 Sep 2014 15:20:52 GMT

See,

in first image when no selection is made,then it show max value as 700 which is maximum in all month bucket,

but in second image when I select more than one interval it wont show any data,I want this data.

Re: Find Max Value for two selected value

juleshartley — Thu, 18 Sep 2014 15:29:10 GMT

If you don't want to change the data model as suggested (please do) then you can use something like:

= If(GetSelectedCount(Interval)=0,

RangeMax( max(Value),max(Value1),max(Value2) ) ,

RangeMax(

SubStringCount(GetCurrentSelections(Interval),'1-3 month' )* max(Value),

SubStringCount(GetCurrentSelections(Interval),'4-6 month' )* max(Value1),

SubStringCount(GetCurrentSelections(Interval),'6-9 month' )* max(Value2) ) )

NB: I've only done up to value2

Re: Find Max Value for two selected value

Thu, 18 Sep 2014 15:29:16 GMT

actually customer has his data in this format,where interval like 1-3 month showing only 1 for yes and 0 for no and value is non zero only for 1 for respective interval month,I cant make changes in their data model

Re: Find Max Value for two selected value

MK_QSL — Thu, 18 Sep 2014 15:29:22 GMT

Change your expression as

if(Interval='1-3 month',max({<[1-3 month]={'1'}>}Value),

if(Interval='4-6 month',max({<[4-6 month]={'1'}>}Value1),

if(Interval='6-9 month',max({<[6-9 month]={'1'}>}Value2),

if(Interval='9-12 month',max({<[9-12 month]={'1'}>}Value3))

)

))

Re: Find Max Value for two selected value

juleshartley — Thu, 18 Sep 2014 15:30:45 GMT

See my answer above then... sorry - they went in a funny order

Re: Find Max Value for two selected value

Thu, 18 Sep 2014 15:38:13 GMT

Thank You julian