topic Re: Summary based on the straight table data in QlikView

Summary based on the straight table data

ashishbhuyekar — Wed, 25 Nov 2020 16:16:04 GMT

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?

ID	Status	Route	Count
1	Available	6	6
2	Available	6	6
3	Change Required	12	12
4	New Requirement	18	15

Summary that i want to show -

Available	2
Change Required	1
New Requirement	1

Re: Summary based on the straight table data

sunny_talwar — Fri, 08 Jun 2018 13:41:33 GMT

What are the expressions from your details chart?

Re: Summary based on the straight table data

ashishbhuyekar — Fri, 08 Jun 2018 13:59:04 GMT

Dimension

Expressions

Max(Route)

FirstSortedValue(Status, -Route)

Re: Summary based on the straight table data

sunny_talwar — Fri, 08 Jun 2018 14:03:05 GMT

May be try this

Dimension

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

Expression

Count(DISTINCT ID)

Re: Summary based on the straight table data

ashishbhuyekar — Fri, 08 Jun 2018 14:44:12 GMT

Thanks Sunny,it worked!!!

Re: Summary based on the straight table data

ashishbhuyekar — Tue, 31 Jul 2018 09:54:40 GMT

Hi Sunny,

Can you please help me on below post?

Show the category based on variable

Thanks in advance.

Ashish