topic Re: Dimension to be restricted in QlikView

Dimension to be restricted

helen_pip — Wed, 21 Sep 2016 16:51:40 GMT

Dear Qlikview user

I have a date field called MonthYear which currently has data from Apr-14-Sep-16

I was wondering what would be the most efficient way of restricting the dimension on the X axis of my graph to only show data from

Apr-15 - Sep 16?

Could anyone point me in the right direction?

Kind Regards

Helen

Re: Dimension to be restricted

miguelbraga — Wed, 21 Sep 2016 16:57:41 GMT

Hey there,

The most efficient way is by inserting a WHERE clause where you define from your start date in this case 01/04/2016 and the end date is 30/09/2016 if your date is in the following format 'DD/MM/YYYY'. Other way arround this is to apply a set analysis like this:

{<OrderDate= {">=$(=min(StartDate))<=$(=max(EndDate))"}> }

Best regards,

Data Architect MB

Re: Dimension to be restricted

Clever_Anjos — Wed, 21 Sep 2016 16:58:12 GMT

Change your expression using Set Analysis

SUM({<MonthYear ={">=Apr-15 <=Sep 16"}>}Value)

Please use exactly the same number format used into MonthYear

Re: Dimension to be restricted

sinanozdemir — Wed, 21 Sep 2016 17:03:43 GMT

Hi,

Have you tried set analysis?

Sum({<Your_Dimension={">=$(=Date(MakeDate(2015, 4, 1), 'MMM-YY'))<=$(=Date(MakeDate(2016, 9, 1), 'MMM-YY'))"}>} Your_Measure)