topic Re: reg: Input Selections in QlikView

reg: Input Selections

Mon, 09 Jan 2012 06:53:59 GMT

Hi All,

I have four input selections in my qlikview report. Whenever i select one selection the rest are getting changed. Is there any possibility to avoid affecting other selections while selecting any one selection.

Hi Ingo,

Please find the attached screen shot. When am choosing the start date from calender object, the rest selections(development,project name_yr) are getting changed on the basis of start date.And also one more thing. The start date and end date are reflecting as same date as it is pointing to the same column on the same table. But i want to show the data on pivot table with the period between start date and end date.

reg: Input Selections

Mon, 09 Jan 2012 07:51:32 GMT

Could you upload your qlikview application or screenshots?

Re: reg: Input Selections

Wed, 11 Jan 2012 08:38:03 GMT

Hi Ingo,

Pleasefind the attached screen shot. When am choosing the start date fromcalender object, the rest selections(deparment,project name_yr) aregetting changed on the basis of start date.And also one more thing. Thestart date and end date are reflecting as same date as it is pointingto the same column on the same table. But i want to show the data onpivot table with the period between start date and end date.

reg: Input Selections

qliksus — Wed, 11 Jan 2012 09:11:05 GMT

If you want 2 different dates from the same date column load the date column one more time

and dont connect it with the already existing table

For example you have Date1 in TAble A

so you create one more load like

load Date1 as Date2 resident TAble A;

now you will have 2 dates for the selection and regarding the selection being reflected

in the column deparment,project name_yr it will reflect bcoz all these data are from the same

table .If you dont want to that to reflect that in the table Use set analysis

reg: Input Selections

Thu, 12 Jan 2012 09:50:32 GMT

Hi Qliksus

Thanks a lot. It was very helpful !!!

I have created start and end date selections by creating two different load statements for the same the date. But I want to show the data in pivot table for the period between start date and end date selections. How to apply the condition to pivot table for getting the data only for the period between start and enddates.

I am very new to Qlik View. Could you please explain what is set analysis and how to apply this for input selections.