I have a problem in expression. I want to get Rebate% using summary sales amount of Parent Customer. If selected 1 Parent Customer result of Rebate% Correct but when Parent Customer selected more than 1 or non select it then result incorrect. I was attached part of data in qvw file. I have been use IntervalMacth function but it not dynamic when select month or year.
I don't see any use of the intervalmatch function in your qlikview document. Anyway, if you want intervals to be match per month,year then you need to use the extended intervalmatch syntax and add the month and year fields as keys on which the intervals should be matched. You can find some examples with this search: https://community.qlik.com/search.jspa?q=intervalmatch+extended+syntax