Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishbhuyekar
Contributor III
Contributor III

Summary based on the straight table data

Hi All,

I am having below data in straight table where Status is dynamically generated based on the expression. Now i want to show summary from the table data. How can show that?

      

IDStatus
Route
Count
1Available66
2Available66
3Change Required1212
4New Requirement  1815

Summary that i want to show -

   

Available 2
Change Required1
New Requirement  1
1 Solution

Accepted Solutions
sunny_talwar

May be try this

Dimension

Aggr(FirstSortedValue(Status, -Route), ID)

Expression

Count(DISTINCT ID)

View solution in original post

5 Replies
sunny_talwar

What are the expressions from your details chart?

ashishbhuyekar
Contributor III
Contributor III
Author

Dimension

ID

Expressions

Max(Route)

FirstSortedValue(Status, -Route)

sunny_talwar

May be try this

Dimension

Aggr(FirstSortedValue(Status, -Route), ID)

Expression

Count(DISTINCT ID)

View solution in original post

ashishbhuyekar
Contributor III
Contributor III
Author

Thanks Sunny,it worked!!!

ashishbhuyekar
Contributor III
Contributor III
Author

Hi Sunny,

Can you please help me on below post?

Show the category based on variable

Thanks in advance.

Ashish