topic Re: Requirement in QlikView

Requirement

deepakqlikview_123 — Tue, 30 Aug 2016 09:16:38 GMT

Hi All,

I have data as per below

Month	Data

Jan	20
Feb	10
Mar	30
Apr	50
May	60
Jun	70
Jul	80
Aug	90
Sept	10
Oct	20
Nov	30
Dec	40

If user selects Feb then it will show Jan+Feb/2

If user selects Mar,Apr,May then it will show Feb+May/2

Can you please suggest.

Thanks

Re: Requirement

richard_chilvers — Tue, 30 Aug 2016 09:25:12 GMT

I'm not clear what your rules for the expression are.

For example, if the user selects Jul, Aug, Sep, what would the result be ?

Re: Requirement

avinashelite — Tue, 30 Aug 2016 09:38:04 GMT

Second part is not clear "If user selects Mar,Apr,May then it will show Feb+May/2" could you explain with an example i.e the output your excepting

Re: Requirement

antoniotiman — Tue, 30 Aug 2016 10:06:50 GMT

Hi,

try

Sum({<Month={'$(=Min(Month)-1)','$(=Max(Month))'}>} Data) /2

Regards

Re: Requirement

deepakqlikview_123 — Tue, 30 Aug 2016 10:24:36 GMT

Hi,

For multiple month selection We need max( month) + Min (month) -1 .

Otherwise show max (month)+ max( month)-1 if selection is only one month

Thanks,

Re: Requirement

avinashelite — Tue, 30 Aug 2016 10:33:01 GMT

I think @antoniotiman‌has already given the solution , did you tried ??

Re: Requirement

deepakqlikview_123 — Tue, 30 Aug 2016 10:41:26 GMT

Hi,

Thanks but this is not working

Thanks

Re: Requirement

sunny_talwar — Tue, 30 Aug 2016 10:45:57 GMT

Is month a text field or is it a dual field created using a date field?

Re: Requirement

Anil_Babu_Samineni — Tue, 30 Aug 2016 10:51:53 GMT

Is This is a Text field which you want to show the O/P

Re: Requirement

deepakqlikview_123 — Tue, 30 Aug 2016 11:23:05 GMT

yeah it is text field

Re: Requirement

sunny_talwar — Tue, 30 Aug 2016 11:32:34 GMT

Either convert your Month field to be a dual field in the script using this:

LOAD Month(Date#(Month, 'MMM')) as Month

or try this expression:

=Sum({<Month={"$(=Pick(MinString(Month(Date#(Month, 'MMM'))-1), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'))","$(=MaxString(Date#(Month, 'MMM')))"}>} Data) /2

Re: Requirement

Peter_Cammaert — Tue, 30 Aug 2016 11:56:59 GMT

Selecting a single month will probably break the calculation. You can fix this by splitting the min/max month sum into two sums. In pseudo-expression code:

=(Sum({set spec for min selected month} Data) + Sum({set spec for max selected month} Data)) /2

Peter