Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Razwan_S
Contributor
Contributor

Counting on a dimension using expresions

Hi

I am new to qlik view and need some help, i have a table such as 

Date | Product | Defaulted

12/12/2022| Loan | Yes

12/11/2022 | Mort | No

12/12/2022 | Loan | No

12/11/2022 | Mort | Yes

12/11/2022 | loan | Yes

11/11/2022 | Loan | Yes

How can i get chart to display the using a date and product dimension and against those how many loand and mort products defaulted and not

for exammple:

in 12/11/2022 there was loans and a mort which had one default against each in the month and there was a mort which had a default against it

 

many thanks

Labels (4)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

In QlikView, create a Straight Table chart. In Qlik Sense, a Table chart. 

Dimensions: Date, Product, Defaulted

Measure: Count(Product)

-Rob