Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I generated Fiscal Quarter and Fiscal Month from Calendar.
In same calendar, i generated a FiscalQuarterSerial which defines 1, 2 and 3 as First , Second and Third Month of Quarter.
If(FiscalQuarter='Q1' and FiscalMonth='Oct',1
If(FiscalQuarter='Q1' and FiscalMonth='Nov',2
If(FiscalQuarter='Q1' and FiscalMonth='Dec',3
If(FiscalQuarter='Q2' and FiscalMonth='Jan',1
If(FiscalQuarter='Q2' and FiscalMonth='Feb',2
If(FiscalQuarter='Q2' and FiscalMonth='Mar',3
If(FiscalQuarter='Q3' and FiscalMonth='Apr',1
If(FiscalQuarter='Q3' and FiscalMonth='May',2
If(FiscalQuarter='Q3' and FiscalMonth='Jun',3
If(FiscalQuarter='Q4' and FiscalMonth='Jul',1
If(FiscalQuarter='Q4' and FiscalMonth='Aug',2
If(FiscalQuarter='Q4' and FiscalMonth='Sep',3)))))))))))) as FiscalQuarterSerial
I need to derive an expression on front end as
If it is Current Quarter and First Month of Quarter, it should retrieve expression 1,
If it is Current Quarter and Second Month of Quarter, it should retrieve expression 2,
If it is Current Quarter and Third Month of Quarter, it should retrieve expression 3,
For this I had written expression as
If(QuarterName(Today(),0) = QuarterName(Today(),0) and FiscalQuarterSerial=1,
Expression 1,
If(QuarterName(Today(),0) = QuarterName(Today(),0) and FiscalQuarterSerial=2,
Expression 2,
If(QuarterName(Today(),0) = QuarterName(Today(),0) and FiscalQuarterSerial=3,
Expression 3)))
However it is not working
I assume this is not working as current selection on front end is not on FiscalQuarterSerial
Is there anyway to achieve this
The primary idea is to generate different expression depending upon the First, Second and Third Month of Current Quarter
Please help
Thanks
Satish
In fact, 227 MB bit vast to download. Make it less if possible? or
Thanks
I removed most of the data and dimensions.
Please check the text box to see what i'm looking for...
See if this file size helps
Any one please help or confirm whether we can achieve this in QlikView or not...
This is fixed..
Adding logic for any reference.
Instead of FiscalSerial, i added logic in expression as
=if(Month(Today())='Oct' or Month(Today())='Jan' or Month(Today())='Apr' or Month(Today())='Jul',
Expression1,
if(Month(Today())='Nov' or Month(Today())='Feb' or Month(Today())='May' or Month(Today())='Aug',
Expression2,
if(Month(Today())='Dec' or Month(Today())='Mar' or Month(Today())='Jun' or Month(Today())='Sep',
Expression3)))
Assuming Oct, Jan, Apr and Jul is always 1st Month of quarter, Nov, Feb, May and Aug is always 2nd Month of quarter and so on....