topic Re: How to show current year data only in QlikView

How to show current year data only

balasundaram — Wed, 10 Sep 2014 05:38:54 GMT

I have designed dashboard.in my reports i have current and previous data.But while open report i want current year data. if i selected previous year in list box i want to get previous data in same report. Please provide any expression like that..

Re: How to show current year data only

sushil353 — Wed, 10 Sep 2014 05:42:37 GMT

hi,

You can create a trigger on open of document.. Select in field> =Year(now())

HTH

Sushil

Re: How to show current year data only

deepakqlikview_123 — Wed, 10 Sep 2014 05:44:20 GMT

Hi U can save report after selection of current year.so that when user open the report in accesspopint he will get current years data.

Thanks,

Re: How to show current year data only

ashfaq_haseeb — Wed, 10 Sep 2014 05:54:17 GMT

Like this

Current Year Sales

=Sum({<Year = {'$(=Max(Year))'}>} Sales)

=Sum({<Year = {"$(vCurrYr)"}>} Sales)

Previous Year Sales

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

=Sum({<Year = {"$(vPrevYr)"}>} Sales)

ASHFAQ

Re: How to show current year data only

Wed, 10 Sep 2014 06:04:50 GMT

Please find the attached file may this will help you.

this is done by trigger

Re: How to show current year data only

vardhancse — Wed, 10 Sep 2014 06:08:15 GMT

we can select the current year in the list box and make the list box as always one selected value.

Then by default current selected year will be default in the dashboard.

And we can create trigger->on open document-clear all.

So that every time we open the dashboard, by default the year will be current.

Re: How to show current year data only

balasundaram — Thu, 11 Sep 2014 12:46:28 GMT

i coudnt get attached file

Re: How to show current year data only

balasundaram — Thu, 11 Sep 2014 13:19:04 GMT

=Sum({<Year = {'$(=Max(Year))'}>} Sales)

its working separate selections only like

while opening its showing current year data,in list box if i selected previous year its showing previous data..but issue is if i selected both previous and current year in list box..its showing only current year...not showing total two year data..

how to solve this issue??

Re: How to show current year data only

ashfaq_haseeb — Thu, 11 Sep 2014 13:22:06 GMT

=Sum({$<Year = P(Year>} Sales)

Will gives you both year.

Make sure to close thread, if it answered

Regards

ASHFAQ

Re: How to show current year data only

balasundaram — Thu, 11 Sep 2014 14:26:20 GMT

not working

Re: How to show current year data only

ashfaq_haseeb — Thu, 11 Sep 2014 15:01:28 GMT

try this

=Sum({$<Year = P(Year)>} Sales)

Regards

ASHFAQ