Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Not applicable

Use annual and quarterly approach in expression

I have this scenario:

I want to have two approach in my expression. First is Annual Approach, second is quarterly approach. For example, If the quarter of "PIN 123" is 1-4, sum(Annual Approach Expression). If the quarter is 1-3 or the whole quarter of the year is incomplete, sum(quarterly approach expression).


I have the expression working properly for annual approach and quarterly approach. The problem is I want to identify whether each data per Per quarter is 1-4 or 1-3/2-4 . For example

if (quarter per PIN is 1-4) then {

//Annual Approach } else {

//Quarterly Apprach }

I attach my qvf file below. PLease see it for yourself. Thank You and Happy Holidays!

PIN           OWNERNUM          QUARTER          PENALTY

123              1000             1               40.00

123              1000             2               40.00

123              1000             3               40.00

123              1000             4               40.00

456              1000             1               20.00

456              1000             2               20.00

456              1000             3               20.00


					
				
			
			
				
			
			
				
1 Reply
Luminary
Luminary

Re: Use annual and quarterly approach in expression

Hi Mark,

what does it have to do with "Qlik Sense - Integration, Extensions and APIs", please can you post this to a general Qlik Diskussion area.

bye

Konrad

Community Browser