Select a value from loaded table

[#1]

Hi,

I have a table with few fields which is in excel and it is loaded to Qlikview the table looks like this

Portfolio, Plan, PlanID

Mob, Mob1, M1

Mob, Mob2, M2

Fix, Fix1, F1

Fix, Fix2, F2

Bun, Bun1, B1

Bun, Bun2, B2

Something like this. I need to create a variable which has the count of no of Mob plans alone. Meaning i need a variable vMobCount which gives me the count as 2 that is two rows which have Portfolio as Mob.

How do I achieve this I tried If statement but there is no selection made anywhere this data is just at the backend and it is used to calculate some values which will be displayed.

Please help me with this. I am pretty new to Qlikview and not sure how to proceed.

[fvelascog72]

Hi, try this:

count({1<Portfolio={'Mob'}>}PlanID)

[#3]

That worked Thanks a ton. Can you explain the logic please. I need to use this in several places.

[fvelascog72]

Hi,

You count PlanID but with Set Analysis just shows the results with Portolio = Mob.

Use 1 and the selections made are not considered.

[#5]

Perfect Thanks a ton. Can I use the same kind of analysis for other aggregate functions like Sum.

[fvelascog72]

Sure. you can use with Sum.

I think you could find more information in help Content. Find Set Analysis.