Discussion Board for collaboration related to QlikView App Development.
Tresesco B is there any way of getting like in this below requirment Default
i want to achieve in the dashboad on open trigger
by default current quarter and next 3 quarters [means 4quarters should be selected]
i have quarter field
for example current quarter is 2018Q3 so my requirment is to be default selction 2018Q3,2018Q4,2019Q1,2019Q2
it should be dynamic ....if i will be in 2019Q1 ...it will treat as 2019Q1 as current like that
Do you have a financial year calendar? What is the quarter for you today (7th Sept 2018)?
No I dont have any calendar... i m getting the Quarter column directly from database ...
current quarter is 2018Q3
it is taking 2018Q4 2019Q1,2019Q2,2019Q3,2019Q4 also
attaching the sample.
Hi Liron Baram any idea on this?
Try search string like:
='=Rank( if(Quarter>=Year(Today())&''Q''&Ceil(Month(Today())/3), -(Left(Quarter,4)*10+Right(Quarter,1))))<5'
Document properties-on open trigger is available. but it will work only once while open the document it will select
No Sir still it is taking from 2018Q4 only it should take the 2018Q3,2018Q4,2019Q1,2019Q2