Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Select a value from loaded table

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.

5 Replies
fvelascog72
Valued Contributor

Re: Select a value from loaded table

Hi, try this:

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

Not applicable

Re: Select a value from loaded table

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

fvelascog72
Valued Contributor

Re: Select a value from loaded table

Hi,

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

Use 1 and the selections made are not considered.

Not applicable

Re: Select a value from loaded table

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

fvelascog72
Valued Contributor

Re: Select a value from loaded table

Sure. you can use with Sum.

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

Community Browser