topic Re: month in QlikView

month

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

I need data for Previous month plus current month until today? any suggestion

Re: month

Chanty4u — Mon, 14 Mar 2016 15:04:15 GMT

chk dis

Set Analysis Current Month vs Previous Month

The Above Function

Re: month

sunny_talwar — Mon, 14 Mar 2016 15:06:20 GMT

May be something like this in your set analysis:

{<DateField = {"$(='>=' & Date(MonthStart(Today(), -1), 'YourDateFieldFormat') & '<=' & Date(Today(), 'YourDateFieldFormat'))"}>}

Re: month

raadwiptec — Mon, 14 Mar 2016 15:24:23 GMT

hi sunny

I need it over a button not on the chart..

I created 2 variables current and previous month but its not working.

Re: month

sunny_talwar — Mon, 14 Mar 2016 15:27:55 GMT

Would you be able to share what you have thus far?

Re: month

raadwiptec — Mon, 14 Mar 2016 15:31:09 GMT

hi sunny,

its a big report.. iam just adding this addition button as adhoc for users. I created 2 variables

=Month(AddMonths(date(Today()),-1)) - Previuos month

=Month(Today()) as Current Month

Both works. in button individually . But I need the report display as until today and February..

Re: month

sunny_talwar — Mon, 14 Mar 2016 16:52:14 GMT

Are these buttons making selection? Are you looking for a button which selects Previous month till today?

Re: month

sunny_talwar — Mon, 14 Mar 2016 16:58:23 GMT

Something like this?

Re: month

raadwiptec — Tue, 15 Mar 2016 08:09:15 GMT

yes something like that

Re: month

raadwiptec — Tue, 15 Mar 2016 08:09:45 GMT

can u tell me what you have used to combine these 2

Re: month

sunny_talwar — Tue, 15 Mar 2016 08:11:19 GMT

Used the following expression for search string:

='>=' & Date(MonthStart(Today(), -1)) & '<=' & Date(MonthEnd(Today()))

Re: month

raadwiptec — Tue, 15 Mar 2016 08:12:19 GMT

hi sunny, but it should not be until 31st mar..it should until today

Re: month

sunny_talwar — Tue, 15 Mar 2016 08:14:23 GMT

You can change the search expression as you would want,

='>=' & Date(MonthStart(Today(), -1)) & '<=' & Date(Today())