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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
sergio0592
Specialist III
Specialist III

How to fetch value in all rows?

Hi all,

I have a straight chart. My first expression is a sum for sales : sum( { < Month={"<=$(=num(Month))"} >  }   Sales)

My second exp is the number of employees in january : =sum( {<Month ={"01"}>} Employee)

So i have value for employee in january (89) but obviously 0 for the other months. How can i get 89 for all rows?

See my attached .qvw sample.

Thanks


1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be use this?

=sum(TOTAL {<Month ={"01"}>} Employee)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni

May be use this?

=sum(TOTAL {<Month ={"01"}>} Employee)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful