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: 
Not applicable

Expression help

Hi All,

I have an expression which is as follows:

(sum({<Qlikview_Line_num={ 1,2,,3,4,5,6,7}>}Max_Points) - this works for me

where Qlikview Line num's are line numbers in a straight table. I want this line to be modified in such a way so that the logic is as follows:

If(month= Jan)

then

(sum({<Qlikview_Line_num={ 1,2,,3,4,5,6/*,7*/}>}Max_Points)  --- Commenting out Line 7

elseif (month=Feb)

then

(sum({<Qlikview_Line_num={ 1,2,,3,4,5,6/*,7*/}>}Max_Points) --Commenting out Line 7

elseif( month= Mar)

then

(sum({<Qlikview_Line_num={ 1,2,,3,4,5,6,7}>}Max_Points)

and so on...

How can this expression be written in Qlikview

Appreciate all your help in Advance

Thanks,

tutan

1 Reply
Nicole-Smith

If(month= Jan, (sum({<Qlikview_Line_num={ 1,2,,3,4,5,6/*,7*/}>}Max_Points),

if(month=Feb, (sum({<Qlikview_Line_num={ 1,2,,3,4,5,6/*,7*/}>}Max_Points),

if(month= Mar, (sum({<Qlikview_Line_num={ 1,2,,3,4,5,6,7}>}Max_Points))

If you want to put an "else" at the end (I'm just going to use sum(Max_Points)), it would go in like this:

If(month= Jan, (sum({<Qlikview_Line_num={ 1,2,,3,4,5,6/*,7*/}>}Max_Points),

if(month=Feb, (sum({<Qlikview_Line_num={ 1,2,,3,4,5,6/*,7*/}>}Max_Points),

if(month= Mar, (sum({<Qlikview_Line_num={ 1,2,,3,4,5,6,7}>}Max_Points), sum(Max_Points))