Select a dimension, time

[#1]

Hello,

I´m already have a few graphs created that use the dimension time like the years of the data.

This is my model:

I would like that when I select "Year" only affect the graph that i want and doesn´t alter the others. And the same for the dimension "accountYear".

Better yet, if possible, then i select the "Year" 2016 also select "accountYear" 2016, and then only affect the graph with the corresponded dimensions.

PS: some graph have the dimension "Year" and others the dimension "accountYear".

What should I do?

[kkkumar82]

Use Alternate States for your filter and chart

[vinieme12]

one option is edit your set expressions to ignore selections on those fields as below

For example, a chart using dimension accountyear

Count(account_id) >>   CHange to   >> Count( {<Year>} account_id)    << This will ignore selections made on Year Field

use vice versa for chart with Year as Dimension add {<accountYear>} to the set

[satheshreddy]

Hi Rafael,

use the alternate states,

or

using Sets:

which dimension you are using the chart, except that and remaining filters u can ignore like below.

sum({<year=,[accountYear]={$}>}sales)

Regards

Sathish

[#5]

Its not correct it still change.

This is my measure:

Avg(Aggr(Sum( {<Year>} account_time_unit), ticket_id,accountMonth, accountYear ))

Didn´t to anything

[vinieme12 · Accepted solution]

Try

Avg({<Year,Ticket_create_time>} Aggr(Sum( {<Year,Ticket_create_time>} account_time_unit), ticket_id,accountMonth, accountYear ))

[#7]

Probably i didn´t understand right.

I did this: Avg(Aggr(Sum( {<Year=,accountYear={$}>} account_time_unit), ticket_id,accountMonth, accountYear ))

on a graph where the dimension was accountMonth, it didn´t display the graph

[#8]

Thankyou, it worked.

This is the graph, also do you know a way that the selection doesn´t change when i select an accountMonth. So that it doesn´t appear only a dot. I prefer like this, all accountMonth

[#9]

No need, already figured out:
Avg({<Year,ticket_create_time, accountMonth = {$(AllMonths)}>} Aggr(Sum( {<Year,ticket_create_time, accountMonth = {$(AllMonths)}>} account_time_unit), ticket_id,accountMonth, accountYear ))

Where AllMonths is 'Jan', 'Fev, ....

Thanks anyway

[#10]

Hello vinieme12

Thankyou for your help.

Now i am trying to replicate your answer to other graphs but i´m not being succesfull, could you explain me the logic behind it?

New i´m trying to the Qlik doesn´t do nothing when i select "accountYear" and "accountMonth" to this measure:

RangeSum(

  Above(

    Count(

              {$<status_name = {$(vPendente)},

              Month,

              Year,

              MonthYear = {"$(='<=' & Date(Max(MonthYear), 'MMM-YYYY'))"}>} ticket_id), 0,  RowNo())) * Avg(1)

PS: the dimension is "Year"