Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mojtabata
Contributor
Contributor

Ignore a field selection but show values for a specific item of that field

Assume that we have an application for a company. The fields are [shopName], [month],[year], [sales].

I want to show a chart for trendline of sales of  a specific shop, 'shop1' on month dimension. This can be done by the following set expression: 

sum({<shopName = {shop1}}sales)

 But, when I select another item in my shopName field, this chart shows 'no data to display'. I want this chart to respect my selection in [month] and [year] fields, but disregard any selection made in [shopName] field.
How can I do that?

2 Solutions

Accepted Solutions
edwin
Master II
Master II

The set analysis phrase  (im assuming you did a typo in your post)

sum({<shopName = {'shop1'}>}sales)

 means, ignore/override shopName selection and only choose 'shop1'

so if this is not working, there is some other issue and its not set analysis thats the issue, so dont look at the set analysis, look elsewhere.  also make sure you have the rt syntax as QV is not forgiving when it comes to syntax


providing the QVW might help identify your issue

View solution in original post

mikaelsc
Specialist
Specialist

also ensure that all your years and months are associated to all your shops... (by adding a record sales = 0 for the years/months where no sales exists for a particular shop ) 

otherwise: you select a year where shop1 doesn't have sales --> you also lose your "shop1 trendline"... 

View solution in original post

2 Replies
edwin
Master II
Master II

The set analysis phrase  (im assuming you did a typo in your post)

sum({<shopName = {'shop1'}>}sales)

 means, ignore/override shopName selection and only choose 'shop1'

so if this is not working, there is some other issue and its not set analysis thats the issue, so dont look at the set analysis, look elsewhere.  also make sure you have the rt syntax as QV is not forgiving when it comes to syntax


providing the QVW might help identify your issue

mikaelsc
Specialist
Specialist

also ensure that all your years and months are associated to all your shops... (by adding a record sales = 0 for the years/months where no sales exists for a particular shop ) 

otherwise: you select a year where shop1 doesn't have sales --> you also lose your "shop1 trendline"...