Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rmdnkevin
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
nishanthi_8
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
MindaugasBacius
Partner - Specialist III
Partner - 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?

nishanthi_8
Creator
Creator

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

rmdnkevin
Contributor III
Contributor III
Author

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
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

nishanthi_8
Creator
Creator

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

rmdnkevin
Contributor III
Contributor III
Author

Thank you so much for the answer, it helps

rmdnkevin
Contributor III
Contributor III
Author

Thank you so much for your response