topic Adding integer number to expression in QlikView

Adding integer number to expression

Thu, 23 Mar 2017 10:18:35 GMT

Hi all,

Need to check condition like

If (Id = ( If(Id=1,vid) + 1 ), 'true','false')

For example : If(Id=1,vid) gives value 1, then add 1 to it which is 2

So given expression works like

If(Id=2,'true','false')

But it is not working. Is there any other solution or need to correct syntax?

Please Help!

Thanks

Sheela

Re: Adding integer number to expression

sumit_ranjan_pa — Thu, 23 Mar 2017 10:23:39 GMT

Can you please share more details what exactly you want to do? As from the details of your question i can see you want to have the calculation to return false always. There will not be a regular case of true at all.

Re: Adding integer number to expression

Thu, 23 Mar 2017 10:41:18 GMT

Hi Sumit,

I want check condition exactly like

If (Id = ( If(Id=1,vid) + 1 ), Name)

Inner if condition value + 1 and need to compare with Outer Id , if it is true ,display name else not.

If (Id = ( If(Id=1,vid) + 1 ), Name)

If (Id = ( 1 + 1 ), Name)

If (Id =2 , Name)

Thanks

Sheela

Re: Adding integer number to expression

sunny_talwar — Thu, 23 Mar 2017 11:40:31 GMT

Where are you doing this? How can a single row have Id = 1 and Id = 2 at the same time? Can you provide a sample to look at?

Re: Adding integer number to expression

Thu, 23 Mar 2017 12:15:15 GMT

Hi sunny,

I am writing this in ' Expression' mode of Straight table.

Sorry, it is like

If (Id = ( If(Id1=1,vid) + 1 ), Name)

Thanks

Sheela

Re: Adding integer number to expression

sunny_talwar — Thu, 23 Mar 2017 12:24:11 GMT

Would you be able to provide a sample?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: Adding integer number to expression

Peter_Cammaert — Thu, 23 Mar 2017 12:34:30 GMT

The + operator doesn't really like adding to NULL. So whenever your inner IF evaluates to false, it will cause NULL (your implicit else value) to be added to 1, which results in NULL again... And logical expressions cannot use the = operator to compare to NULL.

Use Rangesum() to avoid a calculation from returning a NULL value. Like in

IF (Id = (RangeSum(IF(Id1 = 1, vid), 1)), Name)

The RangeSum expression will always return either vid+1 or 1.

Re: Adding integer number to expression

Peter_Cammaert — Thu, 23 Mar 2017 12:36:24 GMT

And make sure that for every evaluation of this expression, both Id and Id1 referrals return exactly one value. Or you will again be comparing to NULL.

Re: Adding integer number to expression

Fri, 24 Mar 2017 09:04:05 GMT

Hi Peter,

Thanks for your reply!

IF (Id = (RangeSum(IF(Id1 = 1, vid), 1)), Name)

This expression meets the requirement, but it is not returning anything.Please Help.

Thanks

Sheela

Re: Adding integer number to expression

sunny_talwar — Fri, 24 Mar 2017 09:10:23 GMT

Can you share few rows of data?

Re: Adding integer number to expression

swuehl — Fri, 24 Mar 2017 09:17:11 GMT

What is the context of your chart expression? A dimension Id?

I assume this has something to do with your other post, where you pass a value for Id and you need a static retrieval vid:

Create a variable vVid in variable overview:

=Only({1<Id = {$(vIdSetDuringLOAD)}>} vid) //Check if Only is appropriate or if you need another aggregation

Check that this returns the proper result, e.g. in a text box.

In your table chart, you can then use

=If(Id = Rangesum(vVid,1), Name)

But as with your other post, a real working sample QVW and expected results would make help much easier...

Re: Adding integer number to expression

Fri, 24 Mar 2017 09:21:34 GMT

Hi Sunny,

I have data like below:

Id Id1 Name

1 1 aaa

2 2 bbb

3 3 ccc

4 1 ddd

5 2 eee

6 1 fff

7 2 ggg

8 3 hhh

9 4 iii

10 5 jjj

I am passing Id value while loading.

Say for example

If i pass Id as 1 , then need to display names in straight table like

aaa

bbb

ccc

If i pass Id as 2 , then need to display names like

bbb

ccc

If i pass Id as 3 , then need to display names like

ccc

If i pass Id as 4 , then need to display names like

ddd

eee

If i pass Id as 5 , then need to display names like

eee

If i pass Id as 6 , then need to display names like

fff

ggg

hhh

iii

jjj

and it continues.

Please help!

Thanks

Sheela

Re: Adding integer number to expression

sunny_talwar — Fri, 24 Mar 2017 09:23:59 GMT

Is this for a dimension? If it is, you might need Aggr() function

Aggr(IF (Id = (RangeSum(IF(Id1 = 1, vid), 1)), Name), Name)

Re: Adding integer number to expression

Peter_Cammaert — Fri, 24 Mar 2017 11:33:15 GMT

What exactly is vid? A variable or a field? And what does it contain when loading your id-id1-Name table?

Re: Adding integer number to expression

Fri, 24 Mar 2017 11:56:30 GMT

Hi Stefan,

Finally solved

Thank you so much:)

As u suggested, declared variable in variable overview and same variable used in Expression.

n Thank you all for your Help:)

Regards

Sheela

Re: Adding integer number to expression

swuehl — Fri, 24 Mar 2017 13:04:52 GMT

You're welcome.

Please always keep in mind that context is very important (and I think the context was unclear in description of your post).

So please add a description of the use case (value set during LOAD, expected result shown in a chart with dimensions X,Y,Z etc.) to every single post, or link to the other posts you described the scenario.

And also consider creating a small, reloadable sample QVW. It makes it much easier to understand your model and data and to work on a solution. Follow the links Sunny posted above to learn how to create and upload a sample QVW.

Regards,

Stefan