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

Need help in expression

I have requirement for a store-sales the product margin should be calculated based on the sales

example: 0-500     level1

        500-1000   level2

       1000-1500+  level3

i tried to use interval match but how can i calculate the sales based on the levels ,sample data was attached

3 Replies
sujeetsingh
Master III
Master III

I do not see any issue in this . Well please explain me the motive of date here?

You can create sum all sales having margin >0 and <=500 as level 1. Post a sample app and explain the functionality.

saradhi_it
Creator II
Creator II
Author

where should i put in the expression for day1 sales 1000 and day2 sales 500

my doubt how can i create condition based on date and and the level buckets

effinty2112
Master
Master

Dear Pardha,

                         Maybe something along these lines:

Pick(RangeMin(3,Ceil(Sum(Sales)/500)),

-------------, //Level 1 calculation here

-------------, //Level 2 calculation here

-------------, //Level 3 calculation here

)


Cheers


Andrew