Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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 (1)
1 Reply
rwunderlich
MVP
MVP

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

Dimensions: Date, Product, Defaulted

Measure: Count(Product)

-Rob