topic Re: Adhoc report selection in QlikView

Adhoc report selection

Tue, 25 Aug 2015 09:10:18 GMT

Hi Community,

I am creating adhoc report which have multiple Dimensions and Expressions but my requirement is User should not have selection more than 10(Dim) / 10(Expr).

Ex:

User can Select maximum 10 only if he select more than 10 dim or 10 expr then error message should appear like 'You have selected more than 10'

Re: Adhoc report selection

kaushiknsolanki — Tue, 25 Aug 2015 09:13:36 GMT

Hi,

Use the calculation condition in "General Tab" under chart properties.

You can give condition as below.

if(Getselectedcount(Dimension) or GetSelectedCount(Expression) >10,0,1)

Here Dimension and Expression is the field from which user will select the Dimension and Expression.

Regards,

Kaushik Solanki

Re: Adhoc report selection

Peter_Cammaert — Tue, 25 Aug 2015 09:20:09 GMT

In your Chart Properties->General->Error Messages, define an error message for condition "Calculation Condition Unfulfilled". You can use something like "Only max 10 Dimensions or Expression selections allowed". This message will be displayed if the Calculation Condition returns false.

Now in Chart->Properties->General->Calculation Condition, enter something like:

(GetSelectedCount(DimensionSelectionField) <= 10) and (GetSelectedCount(ExpressionSelectionField) <= 10)

and you're set.

Peter

Re: Adhoc report selection

Tue, 25 Aug 2015 09:33:08 GMT

Hi Peter,

but user shoul select atleast one and not more than 10

Re: Adhoc report selection

Peter_Cammaert — Tue, 25 Aug 2015 09:40:05 GMT

Then the Calculation Condition becomes:

(GetSelectedCount(DimensionSelectionField) <= 10) and (GetSelectedCount(DimensionSelectionField) >= 1) and (GetSelectedCount(ExpressionSelectionField) <= 10) and (GetSelectedCount(ExpressionSelectionField) >= 1)