topic Re: Comparing with parameters in QlikView

Comparing with parameters

rsdhavle — Mon, 05 May 2014 09:40:51 GMT

I have following scenario:

A is my dimension and has values like S1, S2, S3, S4..

B is expression calculating Sum(Revenue)

C is my threshold parameter which contains values For A dimension lets Say for S1 - Threshold value is 25, for S2 is 50 and S3 - 75 and so on..

I need to display values in B only if value of B is greater than value of C..how can i implement this?

Re: Comparing with parameters

anbu1984 — Mon, 05 May 2014 09:44:00 GMT

Change your Dimension expression to

If(Sum(Revenue) > Threshold, A)

And select "Suppress Null values" checkbox

Re: Comparing with parameters

its_anandrjs — Mon, 05 May 2014 09:45:34 GMT

Can you share any sample data in excel file.

Re: Comparing with parameters

mdmukramali — Mon, 05 May 2014 09:45:53 GMT

Dear ,

can you attach sample data.

Re: Comparing with parameters

rsdhavle — Mon, 05 May 2014 09:46:52 GMT

When i try this logic in expression its is not working and gives all zero values. As you have written i am trying to write it in dimension rather than expression. Lets see if it works.

Re: Comparing with parameters

its_anandrjs — Mon, 05 May 2014 09:50:20 GMT

If i understand you can write

Sum( If(Sum(Revenue) > Threshold, Revenvue))

Re: Comparing with parameters

rsdhavle — Mon, 05 May 2014 09:54:12 GMT

See the attached data. I want to show only those rows if exp1 > Threshold value for given particular client

Re: Comparing with parameters

rsdhavle — Mon, 05 May 2014 09:55:14 GMT

There are different values for threshold for different dimensions. I guess thats why above logic is not working

Re: Comparing with parameters

its_anandrjs — Mon, 05 May 2014 10:01:46 GMT

But you have two expression Exp1 and Exp2 can you elaborate more with sample data.

Re: Comparing with parameters

rsdhavle — Mon, 05 May 2014 10:06:31 GMT

Yes I have 3-4 expression which gives me certain values. Now lets say for client A the threshold is 50. Then I want to show only those rows from expressions which are showing values more than 50%

Re: Comparing with parameters

Mon, 05 May 2014 10:10:10 GMT

Write calculated dimension like this

IF((aggr(Sum(revenue),Product)>aggr(sum(threshold),Product)),Product,null())

enable suppress check box,

add the respective expression you would be able to see the result

Re: Comparing with parameters

its_anandrjs — Mon, 05 May 2014 10:23:26 GMT

Write like below in expression and change according to your expression

Sum( if(Aggr(sum(Exp1),[Client(Dimension)]) > Aggr(sum(Threshold),[Client(Dimension)]), Exp1) )