Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to limit Dimension Values using conditions?

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.

4 Replies
MVP
MVP

Re: How to limit Dimension Values using conditions?

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

israrkhan
Valued Contributor II

Re: How to limit Dimension Values using conditions?

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

Not applicable

Re: How to limit Dimension Values using conditions?

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

Not applicable

Re: How to limit Dimension Values using conditions?

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.

Community Browser