topic Need help in expression in QlikView

Need help in expression

saradhi_it — Fri, 30 Jun 2017 10:27:08 GMT

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

sujeetsingh — Fri, 30 Jun 2017 10:32:57 GMT

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 — Fri, 30 Jun 2017 11:20:38 GMT

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 — Fri, 30 Jun 2017 12:20:46 GMT

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