From Month & To Month ?

[#1]

HI All,

I need to create a simple report, based on Sales like sum(sales).

My point is I am having month in the data, i need to see From Month & To Month filters in Qlikview.

Kindly find the attached excel file.

How can i achieve it ? Kindly help me on this.

Regards,

Helen

[adamdavi3s]

This can be done quite easilly a number of ways.

Either just create a list box with the range of months in it, which the users can select the months they want.

Otherwise have two variables, monthfrom and monthto, let the users select these and then use these in the formula with set analysis

[#3]

HI Davies,

Thanks,Kindly can you help with an example qvw, with the help of variables.

Regards,

Helen

[adamdavi3s]

Hi Helen,

Here is a quick example for you.

Kind regards

Adam

[#5]

Thanks adam, It was coming correct.

Is there any other way for showing same in calendar object.

Thanks,

Helen

[avinashelite]

Create 2 calendar object and in the properties assign the start and end variable to those calendar...it will work the same

[adamdavi3s]

Hi Helen,

Can you explain a bit more about what it is you want to do and I should be able to update the example for you

[#8]

HI Adam,

I need to see From Month in one calendar object & To Month in another calendar object.. based up on the selection need to see the months of Data.

Regards,

Helen

[adamdavi3s · Accepted solution]

Hi Helen,

Please see the attached.

Kind regards

Adam

[#10]

HI Adam,

In My input box object, am getting like this.. Month,month.

but i need to see the one by one. Here i am unable to make selection. Kindly check this

Regards,

Helen