Counting on a dimension using expresions

Razwan_S — Fri, 15 Nov 2024 22:07:17 GMT

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

Re: Counting on a dimension using expresions

rwunderlich — Wed, 13 Jul 2022 23:20:22 GMT

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

Dimensions: Date, Product, Defaulted

Measure: Count(Product)

-Rob