topic Set analysis and inputfields in QlikView

Set analysis and inputfields

Fri, 13 Nov 2009 22:32:38 GMT

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.

Set analysis and inputfields

Fri, 13 Nov 2009 22:57:55 GMT

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

I don't think set analysis should be used.

rgds

Set analysis and inputfields

johnw — Sat, 14 Nov 2009 04:51:09 GMT

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.

Set analysis and inputfields

Mon, 16 Nov 2009 13:54:21 GMT

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.

Set analysis and inputfields

Mon, 16 Nov 2009 14:01:53 GMT

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.

Set analysis and inputfields

Miguel_Angel_Baeyens — Mon, 16 Nov 2009 16:01:17 GMT

I'm sure you can use something like

WeekName(Inputavg())

As your expression to get your results formatted

Set analysis and inputfields

Mon, 16 Nov 2009 16:16:46 GMT

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