topic Default Value in QlikView

Default Value

Anonymous — Fri, 26 Feb 2016 05:08:48 GMT

Hi,

I want to show default value as like Service which is having maximum total volume. If service is deselected it should show message as " Please select a Service"

Thanks in Advance

Re: Default Value

Anonymous — Fri, 26 Feb 2016 05:23:54 GMT

Any sample?

It seems like functionality adhoc dimension we used in Adhoc Reports...check this?

Adhoc reporting in Qlikview‌

Go to: Properties -> General -> Calculation Condition -> if(getfieldselection(Services)>0)

Properties-> General -> Error Message(Bottom Side) -> Select Calculation Condition Unfulfilled -> Your Message

Re: Default Value

deepakqlikview_123 — Fri, 26 Feb 2016 05:26:44 GMT

Please set the message as per balraj's suggestion.

Thanks

Re: Default Value

jagan — Fri, 26 Feb 2016 05:31:45 GMT

HI,

Try like this

Create a variable

vMaxVolumeService

=Aggr(If(Rank(Sum([Total Volume])) = 1, [Service]), [Service])

Now in Sheet Properties ->Triggers -> Select In Field -> Service and give value as =vMaxVolumeService

Re: Default Value

jagan — Fri, 26 Feb 2016 05:34:36 GMT

Hi,

For showing Please select a Service when no service is selected

Chart Properties -> Calculation Condition

=GetSelectedCount(Service) > 0

Now

Chart Properties -> Calculation Condition -> Click Error Messages button -> Select Calculation condition unfulfilled

and give below error message in Custom Message box

Please select a Service

and finally OK -> OK

Hope this helps you.

Regards,

jagan.

Re: Default Value

jagan — Fri, 26 Feb 2016 06:14:45 GMT

Hi,

Check this for max month service

=Aggr(If(Rank(Sum({<Month={'$(=Max(Month))'}>}[Total Volume])) = 1,[Service]), [Service])

Regards,

jagan.

Re: Default Value

jagan — Fri, 26 Feb 2016 06:25:45 GMT

HI,

Try this

=Aggr(If(Rank(Sum({<Month={'$(=Max(Month))'}, [MET <90]={1}>}[Total Volume])) = 1,[Service]), [Service])