Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Arithmetic Expression

Hi Friends !

I'm having a small doubt in applying the arithmetic expression in qlikview.

My Expression is =TP_PREM_LC_1 - TP_DISC_LC_1 + TP_LOAD_LC_1.

when i'm applying this with parenthesis i'm getting null values.Please help me out.

Regards

Krish

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

May be like this.

=sum (TP_PREM_LC_1 - TP_DISC_LC_1) +sum( TP_LOAD_LC_1)


Regards

ASHFAQ

View solution in original post

3 Replies
maxgro
MVP
MVP

maybe, in a chart,  you need some function (aggregation function)

sum (TP_PREM_LC_1 - TP_DISC_LC_1 + TP_LOAD_LC_1)

ashfaq_haseeb
Champion III
Champion III

Hi,

May be like this.

=sum (TP_PREM_LC_1 - TP_DISC_LC_1) +sum( TP_LOAD_LC_1)


Regards

ASHFAQ

ashfaq_haseeb
Champion III
Champion III

Hi,

May be like this.

=sum (TP_PREM_LC_1 - TP_DISC_LC_1) +sum( TP_LOAD_LC_1)


Regards

ASHFAQ