Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
davidl60
Contributor II
Contributor II

How to count items related to a count of market?

Hello All,

I'm new on Qlikview, already found a lot of answers to my questions on this forum , but this time I don't .(maybe because I don't know how phrase my question - see the topic title ).

An example is better than thousands words.

I have a table of items, market (where the item is available).

itemsMarkets
item AFrance
item ACroatia
item ABelgium
item BEngland
item BUruguay
item CArgentina
item CBrazil
item DRussia
item DSweden
item DSwitzerland
item EIceland
item FGermany
item GSpain

I know how to count the number of market per item.

itemscount Markets
item A3
item B2
item C2
item D3
item E1
item F1
item G1

but what I want as a result is a list box like the below, where I could select the 'count market' and display a table of items related to.

count Marketscount items
32
22
13

2 products are available in 3 markets, 2 in 2 markets and 3 in 1

If I select count Market = 1, I want the table

items
item E
item F
item G

I have no clue how to do this.

I searched on this foum but didn't find the right way to phrase this.

Thank you in advance for your help.

David

6 Replies
CarmenReilly
Employee
Employee

Hi David,

Do you want it to display the list of items related to in the same table or in a separate table?

-Carmen

vishsaggi
Champion III
Champion III

may be this?

Add first expr in calculated dimension and 2nd expression in expression tab.

Capture.PNG

Then add Table box object and add items as your field. Like below

Capture.PNG

Then click on your dimension and see.

qlik_ashok
Contributor III
Contributor III

Hello David,

PFA.

davidl60
Contributor II
Contributor II
Author

Hello Vishwarath,

That's exactly what I needed. It works perfectly well.

I now need to understand Aggr - I knew this function was involved but I didn't know how

Thank you very much.

David

davidl60
Contributor II
Contributor II
Author

Hi Carmen,

In a separate one.

Solution given by Viswarath is perfect for what I needed.

Thank you for having had a look to my question.

David

vishsaggi
Champion III
Champion III

Glad it helped. So Aggr() is more like a Group By function. So when you are trying to use any aggregate functions in Dimensions you need to use Aggr() function to support these aggregate functions. And your TOTAL qualifier respects the selections made in listbox.