topic Re: set analysis question in QlikView

set analysis question

josephinetedesc — Fri, 20 Nov 2015 01:44:27 GMT

Hi all this works

- as Classification = Clinical - will not change no matter what Classification is chosen by the user.

(Sum({$<Classification={'Clinical'}>}DurMins))/Sum({1}AvailMins)

This expression is better because if the week has 2 months - it will still calculate correctly.

(Classification = 'Clinical',((sum({$<WeekNum = p(WeekNum), Date_Fin_Month = >}DurMins))/(sum({$<WeekNum = p(WeekNum), Date_Fin_Month = >}AvailMins))))

However, a user needs to make a selection of Clinical.

I would like to make it that a User did not need to select Classification = Clinical but always stays as Clinical.

I have tried combining the two expresssions but it is hard and I end up with commas and brackets left over!

How could I modify the if statement???

Re: set analysis question

tamilarasu — Fri, 20 Nov 2015 02:16:43 GMT

Hi Josephine,

Something like below,

If(Classification = 'Clinical' or Classification <> 'Clinical' ,

Sum({$<WeekNum = p(WeekNum), Date_Fin_Month = >}DurMins) / Sum({$<WeekNum = p(WeekNum),

Date_Fin_Month =>}AvailMins))

Re: set analysis question

josephinetedesc — Fri, 20 Nov 2015 02:59:54 GMT

Thanks Tamil.. still need to choose Clinical to be correct

Re: set analysis question

karthikeyan1504 — Fri, 20 Nov 2015 03:03:19 GMT

Hi Josephine,

have a variable like vClassification = if(getselectedcount(classification)=1 and getcurrentselections(classification)<>'Classification: Clinical', only(classification), 'Clinical')

and refer the variable in set analysis as below,

(Classification = {$(vClassification },((sum({$<WeekNum = p(WeekNum),Date_Fin_Month = >}DurMins))/(sum({$<WeekNum = p(WeekNum),Date_Fin_Month = >}AvailMins))))

Warm Regards,

Karthikeyan.

Re: set analysis question

PrashantSangle — Fri, 20 Nov 2015 03:39:23 GMT

Hi,

try after including Classification='Clinical' in your set analysis.

You dont required if statement.

try like

((sum({$<WeekNum = p(WeekNum),Classification={'Clinical'}, Date_Fin_Month = >}DurMins))/(sum({$<WeekNum = p(WeekNum), Classification={'Clinical'},Date_Fin_Month = >}AvailMins)))

Regards

Re: set analysis question

josephinetedesc — Fri, 20 Nov 2015 04:07:48 GMT

Thank you Max Dreamer - it worked.

so if I try and understand it ...

(

(sum({$<WeekNum),Classification={'Clinical'}, Month= >}DurMins))

(sum({$<WeekNum), Classification={'Clinical'},Month = >}AvailMins))

)

Re: set analysis question

PrashantSangle — Fri, 20 Nov 2015 04:11:59 GMT

Welcome