Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

set analysis alternate state

Hi,

I'he a problem to be solved:


I've a sheet with an alternative state:'pippo'

In this sheet I have:

1) a calendar with alternative state 'inherited'  and the Field 'Giorno'.

2) a list box with a alternative state 'inherited' and the Field 'Commessa'

3)two variables date_lo=MonthStart(min(Giorno))

                      date_hi=MonthEnd(min(Giorno))


3) a pivot table:


the first column has the expression: Sum ({$<Giorno= {">=$(date_lo)<=$(date_hi)"} >} minuti)

the second :Sum(minuti)

The problem is if I select Giorno (01/02/2014,02/02/2014,03/02/2014,04/02/2014), the first column must have the sum of minuti between 01/02/2014 and 28/0272014, then should not change.(it's ok)

The second should change (it's ok).


I select Commessa : the first column should be affected by the filter Commessa . it does not change.


The second column change (It's ok).

thank you Valentina




1 Solution

Accepted Solutions
Highlighted
SunilChauhan
Esteemed Contributor

Re: set analysis alternate state

hi you can Remove $ from expression it will filter your first expression

use below

Sum ({<Giorno= {">=$(date_lo)<=$(date_hi)"} >} minuti) in first expression

hope this helpss

5 Replies
SunilChauhan
Esteemed Contributor

Re: set analysis alternate state

take two dates for High and low dates in two calenders

then select it will work for you

Luminary
Luminary

Re: set analysis alternate state

A quick workaround:

Change your expression to:

sum({$<Giorno= {">=$(date_lo)<=$(date_hi)"} >} minuti)*SubStringCount(Commessa,Commessa)

However, I'm sure someone will come up with a more elegant solution.

Highlighted
SunilChauhan
Esteemed Contributor

Re: set analysis alternate state

hi you can Remove $ from expression it will filter your first expression

use below

Sum ({<Giorno= {">=$(date_lo)<=$(date_hi)"} >} minuti) in first expression

hope this helpss

mikecrengland
Contributor III

Re: set analysis alternate state

Here's a good explanation:

Set Analysis & Alternate States – Quick Tip » The Qlik Board!

Mike

www.fortunecookiebi.com

Not applicable

Re: set analysis alternate state

perfect thank you very much .

greetings Valentina