Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

how to write this expression

Hello All,

if i got table like below


suppiler          code      date

            a                    A              01/01/2015

            b                    A                12/03/2015

            c                    B                02/01/2015

              d                    A+        2 0/03/2016

              a                    A+              31/03/2016

            b                    B              31/03/2016

            c                    C              31/03/2016

            d                    A+        31/03/2016

            e                    A+        31/03/2016

      

so what i am looking  is  :in a pie chart i need to show count of each  code based up on there suppliers  latest date

i mean output:  in a pie chart :dimension= code

                                            expression:?(what shou;d i need to write)

result table:                      code  count(supplier)

                                        A        0  (supplier 'a' latest score is A+)

                                        A+      3

                                        B      1

                                        C        1

thanks

naveen

12 Replies
Chanty4u
MVP
MVP

= count(Max(Date)

Chanty4u
MVP
MVP

=count(Max(Distinct Date),Supplier))

sunny_talwar

This?

Capture.PNG

Dimension: =Aggr(FirstSortedValue(code, -date), suppiler)

Expression: =Count(DISTINCT supplier)

t_chetirbok
Creator III
Creator III

Hi!

dimension: code

expression: count({<date={"$(=date(max({1} date)))"}>}suppiler)

kunkumnaveen
Specialist
Specialist
Author

Hello

its not working in my case ,can you suggest anything diff

t_chetirbok
Creator III
Creator III

can you share your example or post some features of your script or app

sunny_talwar

What isn't working? Can you share your case because I have no idea why this isn't working for you

kunkumnaveen
Specialist
Specialist
Author

A small change in my requirement

                  suppiler          code      date                role   

            a                    A              01/01/2015         eval

           a                    A+             01/01/2015         self

               b                    A                12/03/2015             eval

         b                    A                12/03/2015       self

           a                A+     31/03/2016        eval

            a                    A+     31/03/2016        self

     b                    B          31/03/2016       eval

    b                   B+          31/03/2016       self


so what i am looking  is  :in a pie chart i need to show count of each  code based up on there suppliers  latest date and whose role is eval only

o/p:

suppiler     count(code)

a              1(A+)

b                1 (B) 





Dimension: =Aggr(FirstSortedValue(code, -date), suppiler)

Expression: =Count(DISTINCT supplier)



how to add  role={'eval'} in the above expression ...

please




sunny_talwar

May be this:

Dimension: =Aggr(FirstSortedValue(role={'eval'} code, -date), suppiler)

Expression: =Count(role={'eval'} DISTINCT supplier)


Dimension: =Aggr(FirstSortedValue({<role={'eval'}>} code, -date), suppiler)

Expression: =Count({<role={'eval'}>} DISTINCT supplier)