topic Re: Using variable in QlikView

Using variable

Nagaraju_KCS — Wed, 25 Nov 2020 16:16:04 GMT

HI Community,

i have one straight table.. based on selections i am getting data.

From: 100

To: 200

Here populating table between select ranges.. (100 to 200 between data i am getting)

Exp: IF(vMin='--Select--' or vMax='Select', sum(sales),

if(sum(sales)>=vMin and sum(sales)<=vMax, sum(sales))

This expression working fine..

But my requirement...

If i am enter any one From or To i want to populate data..

Suppose if i am enter 100... i want to show data less than sum(sales)<=100.

I have written this..

IF(vMin='--Select--' or vMax='Select', sum(sales),

IF(vMin=vMin or vMax='--Select--', sum(sales)<=100,

if(sum(sales)>=vMin and sum(sales)<=vMax, sum(sales))

But it's not working..

Please can anyone help me..

Thanks in Advance..

Re: Using variable

sunny_talwar — Mon, 25 Apr 2016 14:06:16 GMT

May be this:

If(vMin='--Select--' and vMax='Select', Sum(sales),

If(vMin=vMin and vMax='--Select--', If(Sum(sales)<=vMin, Sum(sales)),

If(Sum(sales) >= vMin and Sum(sales) <= vMax, Sum(sales))))

Re: Using variable

Nagaraju_KCS — Mon, 25 Apr 2016 17:09:05 GMT

Did i anything wrong??

Please can you check once..

if i am enter 300000.. i want to show 1 record only..

PFA,

Re: Using variable

sunny_talwar — Mon, 25 Apr 2016 17:12:37 GMT

Can you check now?

Re: Using variable

Nagaraju_KCS — Mon, 25 Apr 2016 17:28:24 GMT

Thanks for response..

If i am enter 300000, that should be only one record.

and Contribution% not showing....

Thank you....

Re: Using variable

sunny_talwar — Mon, 25 Apr 2016 17:40:34 GMT

Check now

Re: Using variable

Nagaraju_KCS — Mon, 25 Apr 2016 17:59:18 GMT

I got it.. Anyway thanks

Re: Using variable

sunny_talwar — Mon, 25 Apr 2016 18:01:55 GMT

It was still not what you were looking for?

Re: Using variable

Nagaraju_KCS — Mon, 25 Apr 2016 18:37:19 GMT

This is not my real data, i don't have access to post real data.

That's why i have made sample Application.

Here i am getting proper everything..

Actually these expression i written in my real data.. But percentages not getting proper way... I don't know why

I am confusing with real data... ..

I am fed up with data..

Everything i am getting proper, percentages getting wrong figure.

That's why i am looking for better way of write expression.

Because of that i am keep posting one issue...

Re: Using variable

sunny_talwar — Mon, 25 Apr 2016 18:39:13 GMT

Not sure, but have you got a chance to look at this link?

Preparing examples for Upload - Reduction and Data Scrambling