Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Allowing user to select the month range (Dimension) to view the data

Hi all ,

I have a bar chart which displays the sum(amount) for all the months.

Dimension = month

expression  = sum(amount)

now the user wants to select the months flexibly and not restrained to 12 months periods and can be set within a flexible time frame.


Kindly suggest on how this can be acheived.


Thanks

1 Solution

Accepted Solutions
Highlighted

Re: Allowing user to select the month range (Dimension) to view the data

May be add MonthYear as a dimension instead of just Month?

View solution in original post

7 Replies
Highlighted

Re: Allowing user to select the month range (Dimension) to view the data

May be add MonthYear as a dimension instead of just Month?

View solution in original post

Highlighted
Contributor II

Re: Allowing user to select the month range (Dimension) to view the data

Hi Sunny ,

Yes i have done that , but i want to allow the user to select the number of Month-year he wants to view on the chart.

Any ideas on that ?

Thanks

Highlighted

Re: Allowing user to select the month range (Dimension) to view the data

I am not sure I understand... why can't the user select the month-years they want to? What is going wrong when they try to select there preferences?

Highlighted
Partner
Partner

Re: Allowing user to select the month range (Dimension) to view the data

Hi,

You can create a variable and make it use in the dimension limit tab

Highlighted
Contributor II

Re: Allowing user to select the month range (Dimension) to view the data

can you give some more details as Sunny asked? Cause user can make selections by list box which will reflect on chart so what scenario are you trying to achieve exactly?

Highlighted
Contributor II

Re: Allowing user to select the month range (Dimension) to view the data

Hi Sunny ,

I had implemented this , thanks for the response.

it is serving my purpose.

Thanks

Re: Allowing user to select the month range (Dimension) to view the data

Awesome