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]

Hi Helen,

Try separating with a ; rather than ,

[#3]

thanq 🙂

[#4]

Than Q Adam .

But sort option is not available, Months are coming randomly. how can we do .

[adamdavi3s]

Hi Helen,

Just working on something else, is it just listing them alphabetically?

I've tackled this before so will refresh my memory when I get a second

[#6]

not alphabetically, It should be from Jan, Feb,Mar,.......Dec .. Like that order

[adamdavi3s]

Hi Helen,

If you're adding them manually then as far as I know it should just list them in that order.

However if you're using the concat function then you can add a third parameter to do the sort so in my example file above:

=concat(distinct Month,',',Monthno)

obviously changing the separator as necessary