topic Re: detaching an object from another object in a sheet in QlikView

detaching an object from another object in a sheet

Mon, 14 May 2012 04:31:04 GMT

i have created a sheet in my report and in that sheet i have used multiboxes,pivot tables etc. i have used a pivot table to create a calender. multibox has been used as a selection box for the user to select various parameters of the reports. now whenever a user selects a parameter from the multibox the calender automatically gets activeted and only active values are shown in the calender.

i want it to remain in its original size and shape even after a selection is made. how can i achieve that???

Re: detaching an object from another object in a sheet

Mon, 25 Jun 2012 11:10:47 GMT

Hi Vitul,

Just in case if your using an expression in the pivot table(calendar),

try including the selection(multibox) field into the expression as a set analysis format.

Example:

multibox selection: CalendarDate(Filed Name)

Pivot Table: Expression ---> sum({<CalendarDate=>}1) .

Regards,

Vivekh