topic Re: How to show data from the current year using set analyses? in QlikView

How to show data from the current year using set analyses?

Mon, 23 Nov 2015 19:17:15 GMT

Hello everyone,

I am trying to create a bar chart where i would like to display data from the current year by category, but it should be dynamic, user can view other years by clicking in the filter:

I am just using the field name in my expression, and using the field "Category" as a dimension.

I can´t use triggers, once it will set the rule for all objects in my sheet.

So, how can i create the rule to display the current year in my chart?

Thanks

Re: How to show data from the current year using set analyses?

sunny_talwar — Mon, 23 Nov 2015 19:18:49 GMT

Add this to your expression's set analysis:

{<Year = {"$(=Max(Year))"}>}

Re: How to show data from the current year using set analyses?

sunny_talwar — Mon, 23 Nov 2015 19:25:40 GMT

or this:

{<Year = {"$(=If(GetFieldSelections(Year) = 0, Year(Today()), Max(Year)))"}>}

Re: How to show data from the current year using set analyses?

Tue, 24 Nov 2015 13:11:54 GMT

Hi Sunny,

The name of the field for Year is "Ano".

Should i use the name of the field in the expression you suggested, or should i use "Year" exactly how you wrote?

Thanks

Re: How to show data from the current year using set analyses?

sunny_talwar — Tue, 24 Nov 2015 13:20:21 GMT

So something like this:

{<Ano= {"$(=Max(Ano))"}>}

{<Ano= {"$(=If(GetFieldSelections(Ano) = 0, Year(Today()), Max(Ano)))"}>}

Re: How to show data from the current year using set analyses?

silambarasan — Tue, 24 Nov 2015 13:23:14 GMT

{Year={$(=max(Year))}>}

Re: How to show data from the current year using set analyses?

Mark_Little — Tue, 24 Nov 2015 13:23:50 GMT

Hi,

Or you can try something like {Ano={$(vYear)}}

Create a variable vYear -

Year(Today())

Mark

Re: How to show data from the current year using set analyses?

Tue, 24 Nov 2015 13:26:04 GMT

Thanks for your quick answer!

Should i have 2 expressions in my chart?

One for the dimension and another for the set analyses?

Re: How to show data from the current year using set analyses?

sunny_talwar — Tue, 24 Nov 2015 13:27:32 GMT

No you just need one expression. What is your current expression?

Re: How to show data from the current year using set analyses?

Tue, 24 Nov 2015 13:35:08 GMT

I have two situations:

1) A chart that displays the sum of the field "Occupants" by category

2) A chart that displays the percentage of "Occupants" by category.

Both charts should display data from the current Year.

Re: How to show data from the current year using set analyses?

Anonymous — Tue, 24 Nov 2015 13:37:44 GMT

Hi,

adding to Sunny T advices, you can use an expression like this one:

=Sum({<Ano = {"$(=Year(Today()))"}>} quantity)

where quantity is your metric name.

Re: How to show data from the current year using set analyses?

sunny_talwar — Tue, 24 Nov 2015 13:41:33 GMT

What is the expressions for both of them. You just need to add the set analysis to your existing expressions. We can help you here if you share your expressions here.

Re: How to show data from the current year using set analyses?

Tue, 24 Nov 2015 13:46:28 GMT

Here are the expressions:

1) Sum(Occupants)

2) [Percentage Occupants]

Re: How to show data from the current year using set analyses?

sunny_talwar — Tue, 24 Nov 2015 13:49:00 GMT

See if one of these work:

=Sum({<Ano= {"$(=Max(Ano))"}>}Occupants)

=Sum({<Ano= {"$(=If(GetFieldSelections(Ano) = 0, Year(Today()), Max(Ano)))"}>}Occupants)

=Only({<Ano= {"$(=Max(Ano))"}>}[Percentage Occupants])

=Only({<Ano= {"$(=If(GetFieldSelections(Ano) = 0, Year(Today()), Max(Ano)))"}>}[Percentage Occupants])