To Display only Certain Row in Pivot Table

[#1]

Item	Value
A	100
B	200
C	300
D	400
E	500

Above is a pivot table in QlikSense. Could you please advise the formula to be put in in order to show only Item B and E?

[santiago_respane]

You can do this via Set Analysis or with calculated dimensions.

With set analysis would be something like this:

• In dimensions add Item
• In the expression add =SUM({<Item={"B","E"}>}Value)

With calculated dimension it would be something like this:

• In dimension add calculated dimensions like this: IF(Item = "B" or Item = "E", Item)
• In expression add: SUM(Value)

I prefer using set analysis over calculated dimensions for better performance with big data sets.

Please let me know if this helps.

Kind regards,