topic Re: Compare 2 value with expression in QlikView

Compare 2 value with expression

maxloveiii — Tue, 20 Oct 2015 10:38:31 GMT

Dear Expert

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.

Thanks in advance.

Re: Compare 2 value with expression

Gysbert_Wassenaar — Thu, 22 Oct 2015 11:19:25 GMT

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

Re: Compare 2 value with expression

maxloveiii — Tue, 27 Oct 2015 10:52:55 GMT

Thanks for your reply Gysbert Wassenaar.

I don't use IntervalMath because I think it use static value to matching. May be I went wrong.

Now I can solved this by expression. Like this

Only({$<No = p({$<[Sale Volume From]={"=Sum(LocalAmount)>= [Sale Volume From]"}, [Sale Volume To]={"=Sum(LocalAmount)<= [Sale Volume To]"}>} No)>} [Rebate %])

See attached document for details.

Thanks.

Suphanya

Re: Compare 2 value with expression

Wed, 28 Oct 2015 05:50:00 GMT

Hi,

I have 2 columns in one table as CreationMonth and Completionmonth.

I want to compare sales between these 2 months in a chart.

I took these 2 as dimensions and count of sales as expression.

in x-axis, month dimensions are shown 2 times as

jan,jan,feb feb.

how can I show just months irrespective of createdmonth or completedmonth as dimension, pls help!

Re: Compare 2 value with expression

maxloveiii — Thu, 29 Oct 2015 06:50:39 GMT

Hi Srikanth Rokkam,

Can you share your sample document?