Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am new to QlikView and require kind support in solving the below requirement.
I created a chart object with Month as dimension on X-axis and Sum(Sales) on Y-axis. I need to place three buttons in the document which would change the chart on button click.
On first button click it should display only first 3 months data in chart, similarly second should display 6 months and last button should display 9 months data. Please see the below image.
Please let me know how this can be achieved.
Best Regards,
Vivek
Hi,
possible solutions could be:
1. (horizontal) listbox using the Month field
2. (horizontal) listbox using a Month selector field inline loaded in the script
3. buttons using selection actions
tabSales:
LOAD RecNo() as Month,
Money(100000+Ceil(Rand()*150000)) as Sales
AutoGenerate 12;
tabMonthSelect:
LOAD * INLINE [
Month, MonthSelect
1, 3 months
2, 3 months
3, 3 months
1, 6 months
2, 6 months
3, 6 months
4, 6 months
5, 6 months
6, 6 months
1, 9 months
2, 9 months
3, 9 months
4, 9 months
5, 9 months
6, 9 months
7, 9 months
8, 9 months
9, 9 months
];
hope this helps
regards
Marco
Which month? I believe you don't need buttons you and/or your user could simple use listboxex to select the wished periods - maybe extended by a field "quarter".
- Marcus
or select the bar (3, 6, 9, months) in the chart
Hi,
possible solutions could be:
1. (horizontal) listbox using the Month field
2. (horizontal) listbox using a Month selector field inline loaded in the script
3. buttons using selection actions
tabSales:
LOAD RecNo() as Month,
Money(100000+Ceil(Rand()*150000)) as Sales
AutoGenerate 12;
tabMonthSelect:
LOAD * INLINE [
Month, MonthSelect
1, 3 months
2, 3 months
3, 3 months
1, 6 months
2, 6 months
3, 6 months
4, 6 months
5, 6 months
6, 6 months
1, 9 months
2, 9 months
3, 9 months
4, 9 months
5, 9 months
6, 9 months
7, 9 months
8, 9 months
9, 9 months
];
hope this helps
regards
Marco
Hi Vivek,
please look at attached app.
I used:
a vriable (v_period)
the property "Restrict wich values are displayed..." setting show only "First" and using v_period as Values
I have few dates so I set my buttons to show 1, 2 or 3 months, but you can change action settings for each button
Let me know if it's what you are looking for.
Best regards
Andrea
Thank you so much sir for giving 3 different solutions. I practiced all three methods and got the result.
Glad I could help.
please close your thread if your question is answered.
thanks
regards
Marco
Thanks for your reply. I will try your suggested method as well.