topic Re: month in QlikView

month

raadwiptec — Wed, 06 Jan 2016 14:33:36 GMT

hi all,

I have a chart which needs to display only the previous months data based on a specific column transaction date.

whenever reopen the chart it shows current month. can I change it to previous month

suggest?

Re: month

sunny_talwar — Wed, 06 Jan 2016 14:34:26 GMT

What is the expression that you are using?

Re: month

arasantorule — Wed, 06 Jan 2016 14:38:12 GMT

Hi,

Please use set analysis to show the result of the expression for the current month.

Thanks

Re: month

PrashantSangle — Wed, 06 Jan 2016 15:14:39 GMT

Hi,

Yes you can, But for proper solutions provide more details.

Regards,

Re: month

raadwiptec — Wed, 06 Jan 2016 15:29:27 GMT

hi all ,

I have not used any expression for showing current month. But it takes the current month automatically.

Re: month

sunny_talwar — Wed, 06 Jan 2016 15:30:25 GMT

Do you have the current month selected when you open the application?

Re: month

awhitfield — Wed, 06 Jan 2016 16:09:33 GMT

This would be easier to advise in if you supplied an example .qvw

Andy

Re: month

Anonymous — Wed, 06 Jan 2016 16:10:30 GMT

Hi,

if current month is not selected or no expression for filtering current month.

maybe data is for only current month is loaded.

Have you checked if there is data other than current month?

Check load script for filters on time dimension?

Regards

Neetha

Re: month

PrashantSangle — Wed, 06 Jan 2016 16:39:18 GMT

Hi,

Just check is there any on open trigger set in sheet

also confirm that while closing document did you made any selection in calendar...

Regards,

Re: month

raadwiptec — Thu, 07 Jan 2016 08:01:58 GMT

hi sunny ,

yes current month gets selected when I open the report and is highlighted

for ex: month and year are as list boxes.. so it select 2016 and 01 gets highlighted

Re: month

raadwiptec — Thu, 07 Jan 2016 09:00:50 GMT

Hi all,

Iam using a report with following data

transid ¦ custname ¦ billing date

1 xxx1 12/12/2015

2 xxx2 11/12/2015

3 xxx3 10/12/2015

4 xxx4 09/11/2015

5 xxx5 08/10/2015

My first problem is I have a Year and Month List box. So whenever I open the report fresh. it shows 2016 and chart shows empty as their is no data for 2016. So I want to make it always all data visible. I tried to activate clear all.. it does not work..

secondly I am calling this report via nprinting. and would like to limit the data only to last month before sending to the user. I tried couple of option with billing date as mont(now() -1 ...et etc but it is not filtering

Re: month

HirisH_V7 — Thu, 07 Jan 2016 09:56:04 GMT

Hi ,

In your back end ,

Num(Month([billing date])) as Month,

In Front end Report,

Expression:

=Sum({<Month={'$(=Max(Month)-1)'}>}Sales)

Change expression As per your Requirement.

Hope this Helps,

Regards

Hirish

Re: month

MayilVahanan — Thu, 07 Jan 2016 10:33:47 GMT

Is billing date has 2016 year data?

Re: month

raadwiptec — Mon, 18 Jan 2016 14:52:47 GMT

hi mayil

yes

Re: month

HirisH_V7 — Mon, 18 Jan 2016 15:34:40 GMT

Hi,

Means you need to get Dec data right ,when you open sheet or what ,

For activate sheet action you can keep,

->Select in field, Month , Search String = '>=' & $(=Month(Today())-1)

->On leave sheet Clear All

Or else,

the above post of mine.

HTH,

Hirish