Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Text Based Measure

Is it possible to place a text based measure into a table field without having to calculate it at the load stage (and if that was the only way what sort of syntax would i need to create it).

For example, i have a number of rows of training data

Person, Course, Status

A, Course 1, Complete
A, Course 2, Complete
A, Course 3, Pending
A, Course 4, Rejected

Column A on my table is the person, in this example A, i would like to them count the rows for that person that are complete, and the total rows, and then in a column display the number of complete vs total, i.e. "2/4" in this example. (2 out of 4)

1 Solution

Accepted Solutions
Master II
Master II

@DMG if I understood correctly

Dimension : Pearson

Measure, you can use for example :

count({<Status={'Complete'}>} Course) for count the rows for that person that are complete

count(total<Person> Course) for total rows for that pearson

and =count({<Status={'Complete'}>} Course)/count(total<Person> Course) the number of complete vs total

if you want you can use the text format as :

='('&count({<Status={'Complete'}>} Course)&' out of '&count(total<Person> Course)

 

output:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Master II
Master II

@DMG if I understood correctly

Dimension : Pearson

Measure, you can use for example :

count({<Status={'Complete'}>} Course) for count the rows for that person that are complete

count(total<Person> Course) for total rows for that pearson

and =count({<Status={'Complete'}>} Course)/count(total<Person> Course) the number of complete vs total

if you want you can use the text format as :

='('&count({<Status={'Complete'}>} Course)&' out of '&count(total<Person> Course)

 

output:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

MVP
MVP

@DMG  you can try creating table with dimension person and below expression

=Count({<Status={'Complete'}>}Status) '/'& Count(Status)