Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

expression for total selected values

Hi Experts,

Please find the below data ,

For this data i want the expression for it will tell how many Prdoucts have a value for this  selected period.

YearProductsales
2016a10
2016b-
2017a100
2016b
2015a110
2015b120
2015c-
2014c20
2014a-
3 Replies
Anil_Babu_Samineni

May be this?

Count({<sales -= {'-',''}>} sales)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
PrashantSangle

Hello,

Can you show your final required output screen.

count(<sales-={'-',''}>product)

or

count(if(not wildmatch(trim(sales),'-',''),product))


Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anil_Babu_Samineni

Test done

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)