Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

afuchten
Valued Contributor

dimension overruled by set analys in expression???

I have a table RepairOrders (see below for a small sample)


Serialnumber RMAnumber Status EndDate ... etc
123-123-123 RMA0001 Booked 12/1/2009
123-123-123 RMA0002 Booked 1/1/2010
123-123-123 RMA0003 Open
234-234-234 RMA0002 Booked 1/1/2010
234-234-234 RMA0004 Open
345-345-345 RMA0002 Booked 1/1/2010
345-345-345 RMA0004 Open
456-456-456 RMA0004 Open


At this point I want to show the following (Serialnumber is the only dimension!)


Serialnumber Number Last End Date RMAnumber
123-123-123 3 1/1/2010 RMA0003
234-234-234 2 1/1/2010 RMA0004
345-345-345 2 1/1/2010 RMA0004
456-456-456 1 - RMA0004


But now comes the hard part (at least I find it hard):

We want to filter on the RMAnumber so you get an overview of the serialnumbers of the open RMA


e.g. RMA0004
Serialnumber Number Last End Date RMAnumber

234-234-234 2 1/1/2010 RMA0004
345-345-345 2 1/1/2010 RMA0004
456-456-456 1 - RMA0004


Sounds easy but the number contains the following:

count( {< Status =, RMAnumber = >}[Serviceorders.Service Art Serial])


this since we want all the records for the Serialnumber to be added in the count.

At this moment we get an overview which looks like:


e.g. RMA0004
Serialnumber Number Last End Date RMAnumber

123-123-123 3 1/1/2010 -
234-234-234 2 1/1/2010 RMA0004
345-345-345 2 1/1/2010 RMA0004
456-456-456 1 - RMA0004


seems that the selection made in the dimension is somehow overrulled ... also the not selected items are visible...

Anyone got suggestions

1 Solution

Accepted Solutions
afuchten
Valued Contributor

dimension overruled by set analys in expression???

Found a not so nice solution ...

Now I check with the isnull function if the column is empty ... if so I don't display the value ...

This way all expresions show null ... and the row is not displayed...

Hope someone got a better solution than this!

1 Reply
afuchten
Valued Contributor

dimension overruled by set analys in expression???

Found a not so nice solution ...

Now I check with the isnull function if the column is empty ... if so I don't display the value ...

This way all expresions show null ... and the row is not displayed...

Hope someone got a better solution than this!

Community Browser