topic Re: Display only certain rows in a Straight Table in QlikView

Display only certain rows in a Straight Table

Tue, 15 Oct 2013 13:01:35 GMT

Hi All,

I have a straight table that displays forecast data for a large number of products. I want to create a separate table, based of the same data set that shows only certain rows from the data set. See table 1 attached, as an example of my current table. I want my additional table to look like the table shown in the second attachment. my question is (and it's probably very basic): How can I create the second table so that it shows only the Tech rows?

Alternatively, and this would be my preference, is there any way to structure the first table to always show the Tech level products occupying the top rows of the table (attachment Table 3). unfortunately, the Tech data is not a total of the other items in the table so I couldn't work our a way to lift these items to the top of the table. One unique feature of the TEch data is that the part number field will always be zero.

Any help appreciated

Thanks,

John

Re: Display only certain rows in a Straight Table

Anonymous — Tue, 15 Oct 2013 13:36:14 GMT

There are no attachments (?)

Re: Display only certain rows in a Straight Table

Tue, 15 Oct 2013 13:47:29 GMT

Odd I did attach... let me try again....

Re: Display only certain rows in a Straight Table

Clever_Anjos — Tue, 15 Oct 2013 14:02:00 GMT

Add a set analysis to all expressions, filtering only Tech*

something like

sum({>[Part Name]={"TEch*"}>}yourfield)

Re: Display only certain rows in a Straight Table

Anonymous — Tue, 15 Oct 2013 14:02:51 GMT

There are now...

OK, to show only "Tech", you can use calculated dimension:

aggr(only({<PartName={'Tech*'}>} PartName),PartName)

Make sure to check "suppress when null".

To keep all and have Tech on top - try to sort by expression, like this:

dual(PartName, if(wildmatch(PartName, 'Tech*'), 0, 100000)) + subfield(PartName,' ',2)

Edit: attaching a sorting example.

Re: Display only certain rows in a Straight Table

Tue, 15 Oct 2013 14:08:52 GMT

You can use set analysis:

table 1 with only the tech, use a set that will use the search string capability:

sum({< [Part Name] = {"tech*"}>}, [Your data])

And to get the table without the 4 four lines of tech, that is quite the same (just a minus before the equal sign) :

sum({< [Part Name] -= {"tech*"}>}, [Your data])

Fabrice