topic Between Not Working (challenge one) in QlikView

Between Not Working (challenge one)

kumarnatarajan — Wed, 22 May 2013 09:20:20 GMT

Hi all,

I am useing below mentioned syntex for get count between value. But it is not working. Any one help me

=Count({$<[Scenario Pl]={">= $(=Column(1))"}>*<[Scenario Pl]={"<= $(=Below(Column(1)))"}>}[Scenario Pl])

=Count({$<[Scenario Pl]={">= $(=Column(1)) <= $(=Below(Column(1)))"}>}[Scenario Pl])

find the attached file

Re: Between Not Working (challenge one)

Gysbert_Wassenaar — Wed, 22 May 2013 12:51:18 GMT

You can't use the below function or column references in set analysis expressions. The set is calculated for the entire chart when rows and columns don't exist yet. You'll have to use if statements instead.

Re: Between Not Working (challenge one)

kumarnatarajan — Wed, 22 May 2013 12:55:58 GMT

Hi Gysbert Wassenaar ,

Ok but i want check mutiple value so how it is possible in if statement.

I used below mentioned syntex but it is not working

count(if(Column(1) >= [Scenario Pl] and Below(Column(1)) <= [Scenario Pl],1,0))

Re: Between Not Working (challenge one)

er_mohit — Wed, 22 May 2013 12:57:14 GMT

You have to try on this

i have attached a example

LOAD * INLINE [

A, D

6, q

7, h

8, a

9, c

];

Indirect Set Analysis

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes.

The set p({}) returns the values of CompanyName (Customer) that

purchased Baby Clothes.

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName) - p({$<CategoryName={'SportsWear'}>}

CompanyName)>} Sales)

Sales for Customers who purchased Baby Clothes but not

Sportswear.The first set p({}) returns CompanyName that purchased

Baby Clothes.The second set p({}) returns CompanyName that

Purchased SportsWear.The Unary Operator "-" between the two gives

a list of Customers (CompanyName)that belong to the first but not the

other set.

hope it helps

Re: Between Not Working (challenge one)

kumarnatarajan — Wed, 22 May 2013 13:07:39 GMT

Hi,

It is not working. please find the my attached file.

Re: Between Not Working (challenge one)

kumarnatarajan — Wed, 22 May 2013 13:14:15 GMT

Please find my attached file and give me good solution. it is very help full for me.

Re: Between Not Working (challenge one)

er_mohit — Wed, 22 May 2013 13:19:12 GMT

i doesn't open your file because m working on personal edition

see my example

Re: Between Not Working (challenge one)

kumarnatarajan — Thu, 23 May 2013 05:13:15 GMT

Hi,

I used this below mentioned condition in my exp.,But it's return string value. So how can i dothis in simple eay any one help me.

find the attached file

Re: Between Not Working (challenge one)

kumarnatarajan — Thu, 23 May 2013 05:44:53 GMT

This is Creating condition string.

=0&Replace(Concat( 'if(Column(1)>='& [Scenario Pl] &' And Below(Column(1))<= ' & [Scenario Pl] &',1)','+'),

SubField(Concat( 'if(Column(1)>='& [Scenario Pl] &' And Below(Column(1))<= ' & [Scenario Pl] &',1)','+'),'+',1),'')