expression for total selected values - Qlik Community

prabhas277 · ‎2017-05-02

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.

Year	Product	sales
2016	a	10
2016	b	-
2017	a	100
2016	b
2015	a	110
2015	b	120
2015	c	-
2014	c	20
2014	a	-

Anil_Babu_Samineni · ‎2017-05-02

May be this?

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

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

PrashantSangle · ‎2017-05-02

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 · ‎2017-05-02

Test done

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