topic Re: Disabling the selection on Dimension in QlikView

Disabling the selection on Dimension

Mon, 04 Aug 2014 05:25:50 GMT

Hi,

I have a requirement wherein all the months must get displayed in the chart irrespective of the month selected.I have added month as a dimension in the chart.Please let me know how this could be acheived

Re: Disabling the selection on Dimension

tresB — Mon, 04 Aug 2014 05:27:38 GMT

Use set analysis in the expression of the chart like:

=Sum({<YourMonthField>}Sales)

Re: Disabling the selection on Dimension

aveeeeeee7en — Mon, 04 Aug 2014 05:37:24 GMT

You can use any of the below expressions:

1. Sum({<Month>}Value)

2. Sum({<Month=>}Value)

3. Sum({1}Value)

Kindly replace Month & Value with your Application Field Names.

Regards

Aviral Nag

Re: Disabling the selection on Dimension

jagan — Mon, 04 Aug 2014 05:49:36 GMT

HI,

Just exclude the month values by giving MonthDimensionName= in your set analysis statement

=Sum({<MonthDimensionName=>}MeasureName)

Note: Replace MonthDimensionName and MeasureName with your actual dimension names.

Regards,

Jagan.