topic dimenssion with no efect in QlikView

dimenssion with no efect

Anonymous — Mon, 09 Jun 2014 03:28:37 GMT

hi,

i have deshboard and i want that 2 of the chart will no efect from dimenssion select ( month ),

it will show from first month till today , but the others objects will efected by the month selection.

hope it's understood.

thanks'

yarin.

Re: dimenssion with no efect

eduardo_sommer — Mon, 09 Jun 2014 03:39:57 GMT

Hi,

If you don't want that a selection influence a chart expression, you can do this using set analysis, as in sum(${<month=> value). This syntax will ignore any selection in the field month.

Eduardo

Re: dimenssion with no efect

SergeyMak — Mon, 09 Jun 2014 03:56:40 GMT

small correction:

sum(${<month=>} value)

Re: dimenssion with no efect

senpradip007 — Mon, 09 Jun 2014 04:03:57 GMT

Try this:

Sum({$<Month=, [Other Fimensions]>} [Your field])

Sum({$<Month, [Other Fimensions]>} [Your field])

Re: dimenssion with no efect

jagan — Mon, 09 Jun 2014 04:40:14 GMT

Hi,

If you want to ignore the selections then you can just give MonthDimensionName= in set analysis expression, it ignores the selection of the field.

Ex: sum(${<MonthDimensionName=>} MeasureName)

Replace MonthDimensionName and MeasureName with your actual field names.

Regards,

Jagan.