Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Count of values that change dinamically from a state to another state

Hello all,

I would like to ask you for any advice about the following issue:

I would like to count the different values that changes to a "Box" to a different one when I select two different dates as follows:

ValuesBoxDate
1A20170522
2A20170522
3B20170522
4C20170522
1B20170620
2B20170620
3C20170620
4B20170620
1D20170724
2D20170724
3D20170724
4A20170724

If I select 20170522 and 20170724 I would like to have the count of values exchanges between boxes in the following layout:

Boxes

A -D --> 2 (for the selected dates there are two values that have changed from the box A to the box D)

B- D-->  1  (for the selected dates there is one value that has changed from the box B to the box D)

C- A--> 1  (for the selected dates there is one value that has changed from the box C to the box A)

Any advice/ idea?

Thanks in advance

1 Reply
Highlighted

Re: Count of values that change dinamically from a state to another state

Try this

Dimension

=Aggr(FirstSortedValue(Box, Date) & ' - ' & FirstSortedValue(Box, -Date), Values)

Expression

=Count(DISTINCT Values)


Capture.PNG