topic Re: Display Current Months Data in 12 Month Dataset in QlikView

Display Current Months Data in 12 Month Dataset

nwilliams — Mon, 20 Apr 2015 11:16:36 GMT

Hi,

I think this is fairly easy, but can't figure it out.

I have a dataset that contains 12 months worth of headcount details. I have created a bar chart that shows the count of all the heads by each month. What I want is a straight table to show just the current months data, without having to make a selection.

Is this possible without detaching that bar chart or straight table, or using alternative states?

Thanks

Re: Display Current Months Data in 12 Month Dataset

PrashantSangle — Mon, 20 Apr 2015 11:23:22 GMT

Hi,

Use calculated dimension in Straight table

month(Today())

and your expression.

Note: Match Your Month Pattern it is MonthYear then use MonthName(Today())

Regards

Re: Display Current Months Data in 12 Month Dataset

nwilliams — Mon, 20 Apr 2015 12:19:52 GMT

Struggling here. Getting "Error in set modifier"

=count({<[Headcount.Employment_Type] ={'UK - P'}, MonthName(Today())>}Headcount.SAP_No)

Re: Display Current Months Data in 12 Month Dataset

PrashantSangle — Mon, 20 Apr 2015 12:22:33 GMT

Hi,

Here you required Compared Field

=count({<[Headcount.Employment_Type] ={'UK - P'},DateCompareField ={"=MonthName(Today())"}>}Headcount.SAP_No)

Regards

Re: Display Current Months Data in 12 Month Dataset

nwilliams — Mon, 20 Apr 2015 12:30:15 GMT

Still having issues. The "MonthName" doesn't appear to be turning blue. It returns the total for all 12 months

=count({<[Headcount.Employment_Type] ={'UK - P'},[Calendar.MonthYear] ={"=MonthName(Today())"}>}Headcount.SAP_No)

Re: Display Current Months Data in 12 Month Dataset

PrashantSangle — Mon, 20 Apr 2015 12:31:51 GMT

Hi,

Is it possible to share apps??

Regards

Re: Display Current Months Data in 12 Month Dataset

PrashantSangle — Mon, 20 Apr 2015 12:35:56 GMT

Hi,

I forgot to add $()

use below

=count({<[Headcount.Employment_Type] ={'UK - P'},[Calendar.MonthYear] ={"$(=MonthName(Today()))"}>}Headcount.SAP_No)

Regards

Re: Display Current Months Data in 12 Month Dataset

jonathandienst — Mon, 20 Apr 2015 12:42:02 GMT

Neil Williams wrote:

=count({<[Headcount.Employment_Type] ={'UK - P'},[Calendar.MonthYear] ={"=MonthName(Today())"}>}Headcount.SAP_No)

Assuming the logic is correct, here is the syntax-correct expression:

=count({<[Headcount.Employment_Type] = {'UK - P'}, [Calendar.MonthYear] = {'$(=MonthName(Today()))'}>} Headcount.SAP_No)

HTH

Jonathan

Re: Display Current Months Data in 12 Month Dataset

nwilliams — Mon, 20 Apr 2015 13:29:56 GMT

Thanks, so when I want to do previous month, I was trying to put a "-1" in, but this didn't seem to work. The figure stayed the same. The only thing I was thinking is this needs to be a year date field???

=count({<[Headcount.Employment_Type] ={'UK - P'}, [Calendar.Month] = {'$(=Month(Today(-1)))'}>}Headcount.SAP_No)

Re: Display Current Months Data in 12 Month Dataset

jonathandienst — Mon, 20 Apr 2015 13:34:22 GMT

'$(=MonthName(Today(), -1))' --- for month year

'$(=Month(AddMonths(Today(), -1)))' --- for month only

Re: Display Current Months Data in 12 Month Dataset

nwilliams — Mon, 20 Apr 2015 13:50:59 GMT

Thanks!!!