topic Re: How to limit Dimension Values using conditions? in QlikView

How to limit Dimension Values using conditions?

Thu, 07 Nov 2013 09:38:12 GMT

I have these field/groups: Branch, OpeningDate, ClosingDate, Year, Month, Week

I'm using pivot table with Branch, Year, Month, Week as dimension and Sales as expression. User can select Year, Month, Week and Branch from menu. But, here I want to show only those Branch for which the following condition must satisfy:

* Only those Branch would be visible for which the Branch is open for at least a year, using OpeningDate value of a Branch and Year, Month, Week values from menu. If a specific Branch has OpeningDate and it doesn't complete a year, ie. the branch is opened just 2 months ago, then the Branch should never be shown. Also, if a specific Branch is opened and closed in the period for which user has selected Year, Month, Week, then Branch value shouldn't be displayed too.

Anyone?

Thanks in advance.

Re: How to limit Dimension Values using conditions?

tresB — Thu, 07 Nov 2013 09:41:27 GMT

Could you post a sample app? I guess, you can achieve it using calculated dimension or Set Analysis.

Re: How to limit Dimension Values using conditions?

israrkhan — Thu, 07 Nov 2013 09:46:11 GMT

you can done it by using calculated dimensions, but need to know

1)do you have any status field, like closed or open

2)and if branch in not closed, what will be date in Closing date field, it has null or any default date.

or share sample

Re: How to limit Dimension Values using conditions?

Thu, 07 Nov 2013 09:48:25 GMT

Sorry, I couldn't display sample here. But I need some formula in dimension.

Re: How to limit Dimension Values using conditions?

Thu, 07 Nov 2013 09:50:54 GMT

IsrarKhan: Yes, OpeningDate has value, like, '2008-01-01 00:00:00.000' and if shop is closed then it has ClosingDate value as '2008-01-01 00:00:00.000', else its NULL.