Default Value

[Anonymous]

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

[Anonymous]

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

[deepakqlikview_123]

Please set the message as per balraj's suggestion.

Thanks

[jagan]

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

[jagan]

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.

[jagan]

Hi,

Check this for max month service

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

Regards,

jagan.

[jagan · Accepted solution]

HI,

Try this

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