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: 
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