Showing results as per day

[deepakqlikview_123]

Hi All,

Please find attached QVW file.

In dashboard there are buttons Quarter for Quater wise result diplay,Mpnth for month display

can you please suggest if i want to show the results as per day how is it possible.

Note we are using field

Retail_Quater,Retail_Month,Retail_Day.

Thanks

[deepakqlikview_123]

Hi all,

Please find attached screenshot.I want to add 1 button for displaying results days wise lCan you please suggest on this.

Thanks

[Anonymous]

I didn't get you,

In the same way as you have done for Quarter and Month you can do it for day also.

Whats the issue....

What do you mean by day>> is it Monday, Tuesday....

aur Day in number???

[deepakqlikview_123]

Hi Nitin,

I have not done with  this for quater and month so I need help how to create button for day if i have field Retail_day.

Thanks

[Anonymous]

OK

The concept is there are two charts >>>

When Quarter is selected then one chart is displayed and if month is selected then this chart hides and new chart is being shown,

It is handled via a variable , in your case its vChart.

when vChart =1 then quarter chart is shown and when vChart =2 then Monthchart is shown,

In Same way you can create a new chart which will be shown when vChart=3

[deepakqlikview_123]

I am not getting how to set variable value and how it works in my eg,can you please tell me abt this.

[Anonymous]

PFA

[deepakqlikview_123]

Hi Nitin,

It is working as per exceptation.

Can you please give me steps for this variable and chart creation.

Still I am not able to implement the same on other charts.

Thanks

[Anonymous · Accepted solution]

Steps to show hide>>>.

1> Create a variable . example vChart in your case

2> Create Test boxes as for Quarter, Month, Day, etc.

3> In Actions Tab of text boxes create a trigger for Set variable., provide value for variable vChart as 1,2,3 respectively.

4> Create different charts as for Quarter as dimension, second chart with Month and third with Day as dimension,

5> Now in Layout tab of Charts in Show section in Conditional provide conditions to display.

for Quarter chart, provide vChart=1, for month Vchart=2 and for day, vChart=3.

6> Overlay all charts at on pleace.

Now charts will work as requirement. on click of text boxes respective charts will be shown and others will hide.

[Anonymous]

Also mark correct or helpful to close thread, if you find them correct.