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: 
ecabanas
Creator II
Creator II

Select data that contains certain dimension

Hi,

I'm creating a table calculating a gross marging for certain categories, but is it possible to calculate for example the orders that contain Baby category?

Thank's

Eduard

6 Replies
aarkay29
Specialist
Specialist

Something like this:

sum({<OrderCategory={"Baby"}>}Sales)

ecabanas
Creator II
Creator II
Author

Hi Aar,

Thank's for your answer, but not it is..your formula is the sum of sales for the category Baby, I have 10 categories.

I want to calculate the total of the basquet for the people who bought something from baby category

Best

Eduard

aarkay29
Specialist
Specialist

I am not clear on what exactly you want

can you please explain with sample data

vishsaggi
Champion III
Champion III

What are your dimensions and expressions you are using here?

ecabanas
Creator II
Creator II
Author

Hi,

I'm using a dimension called category. I sum the revenues of all categories, but all what I want is to see the total basket revenues from the orders that contains baby.

thank's

vishsaggi
Champion III
Champion III

I am not sure what you mean by Total Basket revenues? Can you share a sample app and expected output please?