Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
rmdnkevin
New 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
nishanthi_8
Contributor

Re: Make a New Field

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

7 Replies
MindaugasBacius
Valued Contributor III

Re: Make a New Field

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?

nishanthi_8
Contributor

Re: Make a New Field

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

rmdnkevin
New Contributor III

Re: Make a New Field

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

Screenshot_12.png

naddasandeep
New Contributor II

Re: Make a New Field

Hi

You can use aggr function for the same like

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

nishanthi_8
Contributor

Re: Make a New Field

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

rmdnkevin
New Contributor III

Re: Make a New Field

Thank you so much for the answer, it helps

rmdnkevin
New Contributor III

Re: Make a New Field

Thank you so much for your response