topic Re: FROM Date - To Date filter without Variable in QlikView

FROM Date - To Date filter without Variable

sanketkhunte — Fri, 20 Dec 2013 06:15:28 GMT

Hi Team,

In dashboard, there is frequently requirement of filtering data with selecting START DATE AND END DATE filter. (from date and to date).

I have achieved this functionality by using variables and SET ANALYSIS function. Here I would like to ask : Can we implement this functionality without using variables.

Thank you in advance.

Regards

Sanket

Re: FROM Date - To Date filter without Variable

sujeetsingh — Fri, 20 Dec 2013 06:23:58 GMT

Just seems not feasible .

How can you make any expression or calculation dynamic without any parameter or variable.

But yes one thing you can do is that provide to filters as

-----Date From (it consist of all dates )

-----Date To (it consist all date s too)

Now you can call the selection of these two filters to limit your expression by using call function

GetFieldSelection()

Hope it helps you .

Re: FROM Date - To Date filter without Variable

Anonymous — Fri, 20 Dec 2013 06:33:06 GMT

Hi,

first of all there is no problem in using variable in your application, but anyway if you do not desire

then you have to use some other functionality available in qlikview to acheve the same

just look below the example you may require to declare variables globally but this scenario is done

without using variable

Question : We have the create_date for a CI . It expires after 36 months from create_date. How do I calculate the count of CIs that expires in the next 30 days?

ans.

lOAD

AddMonths(DateDimension, 36) AS ExpiryDate

FROM DataSource;

Now use this expression to get the count of CIs that expires in the next 30 days

Count({<ExpiryDate={'>=$(=Today())<=$(Date(Today() + 30))'}>} CI)

anant

Re: FROM Date - To Date filter without Variable

jagan — Fri, 20 Dec 2013 06:49:08 GMT

Hi,

If you don't to use variables, then provide List box with dates and ask user to select From and To dates from 2 list boxes, then based on the selection write set analysis expression to filter those values.

Regards,

Jagan.

Re: FROM Date - To Date filter without Variable

sanketkhunte — Mon, 30 Dec 2013 08:26:30 GMT

Thanks Jagan

Re: FROM Date - To Date filter without Variable

sanketkhunte — Mon, 30 Dec 2013 08:26:39 GMT

Thank you Anant

Re: FROM Date - To Date filter without Variable

Anonymous — Mon, 30 Dec 2013 10:33:34 GMT

Alternate states will also help you out in this scenario.

Create two list box with all dates .

and provide different alternate states to both list boxes respectively,

you can play with set analysis based on it.....

this will remove the need of defining variable......