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: 
hutchinsonbss
Contributor II
Contributor II

Simple question "Count"

Sorry for this simple question, but there are my first steps in Sense

I'm tring to represent a graphic whit a cumulative date (dimension)  by data, I have a table whit a colum "Risk" and inside two possible values, 0 and 1

I only want to count  each value = 1 and Value =0

I try whit   Count(IF([Tipo Risk<1,1,0))  but does not work

Can you help me?

6 Replies
OmarBenSalem

as an expression : count({<Risk={1}>}yourmeasure)

and

another one:

count({<Risk={0}>}yourmeasure)

if you want cumulative by date: change your expression as follow: (make sure to sort by date; in the sort tab, put the date above the 2 expressions):

rangesum(above( count({<Risk={1}>}yourmeasure) ,0,rowno()))

rangesum(above( count({<Risk={0}>}yourmeasure) ,0,rowno()))

OmarBenSalem

with the last expressions; in each date, it will calculate the count of risk=1 for that date and all the previous counts for the previous dates

simon_minifie
Partner - Creator III
Partner - Creator III

Hi Marcos,

Set analysis may be a better fit here.

Count({<Risk={1}>}Data)

and

Count({<Risk={0}>}Data)

Cheers,

Simon

hutchinsonbss
Contributor II
Contributor II
Author

Works

Thanks ++

hutchinsonbss
Contributor II
Contributor II
Author

Works, thanks

OmarBenSalem

If your question has been asnwered, please close the thread by marking the correct answer as so