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: 
Jamal
Contributor III
Contributor III

Chart Pivot Table

HI, 

Please, I need your help.

I have different tables :

  1. PROD ( my sales by Mark and place (CDLOC), and RIS, with different dateprodsql (example : 22/02/2022; 12/10/2021;...)
  2.  Vente ( market sales by Mark and place (CDLOC),  with dateprodsql= 30/12/2022 OR 30/12/2021)
  3. MARKA ( MARK, CODE_MARK,..)
  4. AGENCE ( RIS)
  5. MasterCalendar

Jamal_2-1682507626054.png

 

I need to obtain 2 columns mysales ( count  MARK) AND market ( sum(NBRE) byCDLOC,RIS AND MARK , like this 

Jamal_3-1682507914278.png

but, I get this 

Jamal_4-1682508080773.png

I have tried to aggregate by year but I got total  for market

Jamal_5-1682508862320.png

Thank you.

 

 

 

 

 

 

0 Replies