topic Set Analysis/Calc Dimension - Lazy search in QlikView

Set Analysis/Calc Dimension - Lazy search

Tue, 15 Nov 2011 20:52:09 GMT

I have a group of tables all connected by an id:

Items:

item_id

display_name

Attributes:

item_id

attribute_name

attribute_value

Tickets:

item_id

ticket_type
ticket_number

plus many more fields for the three tables.

I would like to make a pivot table that is displaying this information.

Then I would like to have an input box where a person would be allowed to enter a ticket number.

Pivot chart order would be like: item_id -> display name -> ticket_type -> ticket number

The issue I'm running into is this: say a ticket number is selected, this ticket number will not (I can verify on my end) match a ticket number of a different ticket type. As a result, this will exclude all the other ticket types from the item they are connected to. I would like for them to be displayed.

Essentially I would like to display all the information of an item where that item happens to have a ticket with a number that matches what is entered.

I think I could maybe do this with set analysis and an expression, but there really isn't anything I want to aggregate over my data for in this particular example. Is there a way I can do set analysis on a chart without using any type of aggr function? Thanks.

Set Analysis/Calc Dimension - Lazy search

lironbaram — Wed, 16 Nov 2011 08:01:48 GMT

hei can you post an example datamean while maybe you can filter your dimension

let say you pick a ticket number

then your item dimension would be

aggr(only({<Item_id=P(Item_id),ticket_number=>}display_name),Item_id)

hope its helps you

Set Analysis/Calc Dimension - Lazy search

Thu, 17 Nov 2011 15:18:24 GMT

data would look something like:

item_id, display_name

1, m5000

2, m9000

3, m9000a

item_id, attribute_name, attribute_value

1,power_on,true

1,state,planned

2,power_on,false

2,state,present

3,power_on,true

3,state,present

item_id,ticket_type,ticket_number

1,purchase,888004455

1,development,112233

2,purchase,888004455

2,development,223344

3,purchase,999005533

3,development,335566

So when I select ticket number 888004455 i'd like to see all the information of items 1 and 2 but not three in addition to the development tickets of item 1 and 2.