topic Re: Inputfield for a selection in QlikView

Inputfield for a selection

Mon, 27 Apr 2015 12:45:56 GMT

Good evening,

I used a a inputfield to specify a value that can change in my table, a number of stores. But considering my table contains a lot of rows, how to edit the field value for a selection? for exemple add a store and go from 4 to 5 stores in one time instead of changing the value for each line.

Thank you a lot !

Re: Inputfield for a selection

sunny_talwar — Mon, 27 Apr 2015 13:00:57 GMT

I don't think this is possible with any of the functionalities available within QlikView. There might be a macro available which might let you do this.

Best,

Sunny

Re: Inputfield for a selection

Mon, 27 Apr 2015 13:05:26 GMT

Alright, thank you,

Is there any possible way to creat a variable that will take different values depending on a field value? My goal is in an expression to devide the Sum of sales per the number of stores, that can change in time and that I don't have in my original table. Thank you.

Best regards,

Yasser

Re: Inputfield for a selection

sunny_talwar — Mon, 27 Apr 2015 13:08:52 GMT

Do you want to create a single variable which contains multiple values? An example would be very helpful in understanding what you ultimate goal is.

Best,

Sunny

Re: Inputfield for a selection

buzzy996 — Mon, 27 Apr 2015 13:15:25 GMT

as sunny said,this is not possible simply..u have to try with macros and web services to update back ur data on multiple places.

Re: Inputfield for a selection

Mon, 27 Apr 2015 13:16:42 GMT

Where the Number of stores is what I want to get by making a condition on the month

Re: Inputfield for a selection

sunny_talwar — Mon, 27 Apr 2015 13:17:04 GMT

Here, have a look at this sample application I found on the community. This uses a Macro but does your job of inputting multiple values very easy. (PFA)

Best,

Sunny

Re: Inputfield for a selection

sunny_talwar — Mon, 27 Apr 2015 13:23:18 GMT

Look at the attached application, does this help??

Best,

Sunny

Re: Inputfield for a selection

Mon, 27 Apr 2015 13:25:43 GMT

Thank you a lot

Re: Inputfield for a selection

sunny_talwar — Mon, 27 Apr 2015 13:27:03 GMT

Not a problem, do look at the other sample application I have attached. You may find that useful also.

Best,

Sunny

Re: Inputfield for a selection

Mon, 27 Apr 2015 14:05:49 GMT

I did the same as at the attached file, but I have a probleme, for the table with period and number of stores, I have as many lines as sales lines. Is it normal?

Re: Inputfield for a selection

sunny_talwar — Mon, 27 Apr 2015 14:09:42 GMT

That should not happen, If period are all the same, they should all be clubbed together into one. Do you have any other field in that particular table box???

Best,

Sunny

Re: Inputfield for a selection

Mon, 27 Apr 2015 14:11:52 GMT

Yes I do. I have a field date transaction from wish I create fields: Day DayMonth and Month and Hour. In the last table I picked the Month field and added the number of stores. But as an output I have a table with a lot of each month

Re: Inputfield for a selection

sunny_talwar — Mon, 27 Apr 2015 14:16:59 GMT

From my what I understand, you need to do this in your script:

[Number of Stores]

Month:

LOAD DISTINCT MonthName(Date) as Month (This 'Month' should be the same name as in your fact table or master calendar)

[Number of Stores]

Resident [Master Calendar] or [Fact Table];

Then on the front end of the application create a table box with just Month and Number of Stores and I think it should fix the issue for you.

Hope this helps.

Best,

Sunny

Re: Inputfield for a selection

Mon, 27 Apr 2015 14:56:56 GMT

I tried this but I have a error message saying I have a duplicated keys

Re: Inputfield for a selection

sunny_talwar — Mon, 27 Apr 2015 14:58:09 GMT

Is there any way you can share your or a sample application?

Best,

Sunny