Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JJaky
Contributor III
Contributor III

Putting specific rows in a table

Hi all, 

I'd like to make a table with specific rows and count the value of interest for 1 dimension. For example, I want  to choose 5 stores from my long list and count the number of products just for one type of category for these stores. 

This table (countries and category) shouldnt change with other filters.

Can anyone suggest a way to do that please? Thanks in advance!

Labels (2)
1 Solution

Accepted Solutions
AnkitMadhukar
Creator
Creator

If its less than 5-10 countries , the easiest way would be use the if condition or match function.
For eg

 If(Match(Countries,'A','B','C','D','E')>0, Countries).

It will give a dimension field with only these 5 countries. Can you  try this and check if it works for your use case.
Also, Suppress nulls in the chart where you are using this field.

View solution in original post

6 Replies
QFabian
Specialist III
Specialist III

Hi @JJaky , for that, you need to know about set analysis and maybe alternates states.

Set Analysis allows you to change filters for your aggregation

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

 

Alternate States, can create another field to use to create another State of selections

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/alter...

Here a little example about set analysis, its going to count Number of products, considering filters, except Country and is going to show all available countries, and in Ctegory is going to filter with a text with your desired Category.

count(${<Country =  , Category = {'TextOfCategoryWanted'} >} [number of products]

QFabian
JJaky
Contributor III
Contributor III
Author

Hi @QFabian , thanks for your reply, 

but I need to limit my table with just few lines from all available countries. I think I should look at the dimension limitations, but I dont have a clearer idea yet. Also, my list of countries shouldnt change because of other filters, only the values should (for days, weeks etc).

AnkitMadhukar
Creator
Creator

Hi @JJaky ,
If you apply the dimension limit  for eg top 5 (lets say for countries) , the values will change based on the filters you select as it will now compute top 5 countries based on whatever measure you choose. 
Is there an specific requirement for countries not changing ? 
Can you not show all the countries ? 

If you want to have the countries as same always , you can create a  master dimension which is subset of  your country dimension (To include only A , B , C ...  countries ) and use this in your visual.

JJaky
Contributor III
Contributor III
Author

Hi @AnkitMadhukar , so how do you create a master dimension with subset of countries? 

I have a column "Countries" with around 80 countries.  TIA

AnkitMadhukar
Creator
Creator

If its less than 5-10 countries , the easiest way would be use the if condition or match function.
For eg

 If(Match(Countries,'A','B','C','D','E')>0, Countries).

It will give a dimension field with only these 5 countries. Can you  try this and check if it works for your use case.
Also, Suppress nulls in the chart where you are using this field.

JJaky
Contributor III
Contributor III
Author

hi @AnkitMadhukar , 

i used if (wildmatch(countries...., and it worked perfectly.

Thanks a lot!