Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
how can i get current financial year months like right now finantail year 2014-2015 is going on and current month is june ,i need to create such a field it should store months Apr May June just three if july comes up it should add july to its list... i need help asap,
thank you
You could try like:
Load
Month(InQuarter(Today(), YourDateField, 0)) as ThisQuarterMonths
hi , this my table structure how can i do in this ,
i dont have date field ,what should i use ?
So you don't have a date field. Well try like:
Load
Month(InQuarter(Today(), Makedate(1,Month,1), 0)) as ThisQuarterMonths
hi,
by using Month(InQuarter(Today(), Makedate(1,Month,1), 0)) as ThisQuarterMonths i am only getting december ,,??
i should get apr may june right?
Could you post your sample qvw?
due to security reasons i cant ,sorry
You don't have to be. Just need to know: Preparing examples for Upload - Reduction and D... | Qlik Community