Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Make a New Field

Hi, everyone.

I have a field in main table like this :

Screenshot_13.png

The problem is, can I make a new field that contain a value from it ? For instance, I need field CountofSubmittedData, and the value will be the count of Submitted Data from the main table.

Thank you everyone

- Kevin

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Then you could simply use count(status)  and group it by the fields in the table

View solution in original post

7 Replies
Highlighted
Specialist III
Specialist III

This may do the job:

Left Join (MasterTable)

Load Status

    ,Count(Status) as StatusCount

resident tmp

Group by Status

;


Why do you avoid Count function in Chart type table?

Highlighted
Creator
Creator

You could use count(status). But what exactly is your need ? You need at script or chart level ?

Highlighted
Contributor III
Contributor III

I already use count function for making chart of it, but I need its value in a field, just like this :

Screenshot_12.png

Highlighted
Contributor III
Contributor III

Hi

You can use aggr function for the same like

load the table and aggr(count(status),status) as Counted data in the script

Highlighted
Creator
Creator

Then you could simply use count(status)  and group it by the fields in the table

View solution in original post

Contributor III
Contributor III

Thank you so much for the answer, it helps

Highlighted
Contributor III
Contributor III

Thank you so much for your response