topic Re: Future Data in QlikView

Future Data

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

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

2017Q1

2017Q2

2018Q4

2019Q1

2019Q2

2019Q3

2019Q4

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

thanks

Sony

Re: Future Data

tresB — Fri, 07 Sep 2018 09:02:57 GMT

Do you have a financial year calendar? What is the quarter for you today (7th Sept 2018)?

Re: Future Data

soniasweety — Fri, 07 Sep 2018 09:08:25 GMT

No I dont have any calendar... i m getting the Quarter column directly from database ...

current quarter is 2018Q3

Re: Future Data

soniasweety — Fri, 07 Sep 2018 09:32:18 GMT

it is taking 2018Q4 2019Q1,2019Q2,2019Q3,2019Q4 also

='=Rank(Quarter<=Year(Today())&''Q''&Ceil(Month(Today())/3), Quarter)<5'

Re: Future Data

soniasweety — Fri, 07 Sep 2018 09:34:13 GMT

Hi tresesco

attaching the sample.

Re: Future Data

soniasweety — Fri, 07 Sep 2018 09:45:59 GMT

Hi Liron Baram any idea on this?

Re: Future Data

tresB — Fri, 07 Sep 2018 09:48:44 GMT

Try search string like:

='=Rank( if(Quarter>=Year(Today())&''Q''&Ceil(Month(Today())/3), -(Left(Quarter,4)*10+Right(Quarter,1))))<5'

Re: Future Data

manoj217 — Fri, 07 Sep 2018 09:49:48 GMT

Document properties-on open trigger is available. but it will work only once while open the document it will select

Re: Future Data

tresB — Fri, 07 Sep 2018 09:50:31 GMT

Check attached.

Re: Future Data

soniasweety — Fri, 07 Sep 2018 09:52:32 GMT

No Sir still it is taking from 2018Q4 only it should take the 2018Q3,2018Q4,2019Q1,2019Q2

Re: Future Data

soniasweety — Fri, 07 Sep 2018 09:55:56 GMT

yes manoj. it should be like that only.

Re: Future Data

soniasweety — Fri, 07 Sep 2018 09:56:25 GMT

thanks sir its working