Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harisin22
Contributor II
Contributor II

Relational tables

Hello:

I am new to Qlik Sense - would appreciate any help or resources on this:

I have seven relational tables (tbl1, tabl2, etc), all linked on a specific files (fieldX). There are one-to-many (or one-to-none) relationships between the tables. How do I write a COUNT expression that counts the number of records in a given table on "filedX" (to create a measure that can then be used in visualizations)?

Thanks!

2 Replies
YoussefBelloum
Champion
Champion

Hi,

you can create your measures on the back-end (script) or on the front-end (charts).

if you need to count the number of records:

on the back-end, you will need to use Count(Field) with a Group by statement.

on the front-end, you will need to use Count(Field) on a chart with the dimension you want.

it would be interesting if you can attach some data here and the expected output via screen shots.

harisin22
Contributor II
Contributor II

Hi Youseef -

First - I accidentally created two posts for this, so there's another parallel discussion going on this.

Second - this is literally my first couple of hours of using Qlik Sense - so not even sure how to access or edit the back-end scripts. Are you talking about scripting in the "Data load editor" section?

Can you share any resources on editing scripts in Sense?

Hari