Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Where go wrong with this expression ? sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar)) , it display null.

sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar))

Hi All

I have a Pivot table 1 , which is working fine, i like to convert it to straight table.

Dimension :-

COMPANY_PAY

=If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2),

If(aging_ar >= 61 and aging_ar <= 90, Dual('61-90', 3),

If(aging_ar >= 91 and aging_ar <= 120, Dual('91-120', 4), Dual('>121 ', 5)))))

 

Expresion :-

Sum(total_ar)

I like to convert it into straight table. Hope some one can advise me.

I try on Table 2 it display null :-

Dimension :-

COMPANY_PAY

Expresion :-

sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar))

The error is above expression.

Pauk Yeo

1 Solution

Accepted Solutions
prma7799
Master III
Master III

5 Replies
paulyeo11
Master
Master
Author

Hi All

Enclosed My QVW file.

If the expression no more syntax error , the first column of table 1 and 2 should be display same amount.

Paul Yeo

Anil_Babu_Samineni

I haven't open your application. Condition should like below

sum(If(aging_ar >= 1 and aging_ar <= 30,total_ar))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prma7799
Master III
Master III

Hi Paul Sir,

Try this

sum(If(aging_ar >= 1 and aging_ar <= 30,total_ar))

prma7799
Master III
Master III

PFA....

paulyeo11
Master
Master
Author

Hi P M

thank you very much it work fine now.

Paul