Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ashishbhuyekar
New 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

Re: Summary based on the straight table data

May be try this

Dimension

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

Expression

Count(DISTINCT ID)

View solution in original post

5 Replies

Re: Summary based on the straight table data

What are the expressions from your details chart?

Highlighted
ashishbhuyekar
New Contributor III

Re: Summary based on the straight table data

Dimension

ID

Expressions

Max(Route)

FirstSortedValue(Status, -Route)

Re: Summary based on the straight table data

May be try this

Dimension

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

Expression

Count(DISTINCT ID)

View solution in original post

ashishbhuyekar
New Contributor III

Re: Summary based on the straight table data

Thanks Sunny,it worked!!!

ashishbhuyekar
New Contributor III

Re: Summary based on the straight table data

Hi Sunny,

Can you please help me on below post?

Show the category based on variable

Thanks in advance.

Ashish