Set analysis and inputfields

[#1]

I have a table with the following fields:

Project No

Gate

Planned date for passing gate

Actual date for passing gate

So I have several rows for each project number but I want one row for each instead. I want it to be displayed in QlikView like this:

ProjNo G1 Planned G1 Actual G2 Planned G2 Actual G3 Planned G3 Actual

And I want the values for Actual dates to be inputfields.

I could display it like I wanted to with set analysis but I don't know how to make some of the fields inputfields. It doesn't seem to work when using set analysis.

I'm new to set analysis so I don't know if I'm missing something obvious.

[#2]

Please have a look at CROSSTABLE function in your manual, it will help you.

I don't think set analysis should be used.

rgds

[johnw]

I think you could do it with regular old pivot table. Project No and Gate as dimensions, with Gate across the top. Two expressions, Planned and Actual. No set analysis. It doesn't seem to me that you need to modify the data model itself, and crosstable works in the opposite direction from what you want anyway.

[#4]

OK. But it doesn't seem to work with inputfields in the pivot table. It works in a regular table box but not in the pivot table. I want to be able to edit the date for when the gate was actually passed.

[#5]

It works if I use inputavg() in the expression but then my problem is that I have formatted my dates with weekname() and when I use inputavg() it gets formatted as regular dates again.

[Miguel_Angel_Baeyens]

I'm sure you can use something like

WeekName(Inputavg())

As your expression to get your results formatted

[#7]

If I do that, the format is correct but then I cant change the values anymore. So Inputavg() stops working.