topic Select a value from loaded table in QlikView

Select a value from loaded table

Fri, 12 Jun 2015 07:09:26 GMT

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.

Re: Select a value from loaded table

fvelascog72 — Fri, 12 Jun 2015 07:14:21 GMT

Hi, try this:

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

Re: Select a value from loaded table

Fri, 12 Jun 2015 07:21:00 GMT

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

Re: Select a value from loaded table

fvelascog72 — Fri, 12 Jun 2015 07:25:08 GMT

Hi,

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

Use 1 and the selections made are not considered.

Re: Select a value from loaded table

Fri, 12 Jun 2015 07:28:56 GMT

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

Re: Select a value from loaded table

fvelascog72 — Fri, 12 Jun 2015 07:32:48 GMT

Sure. you can use with Sum.

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