topic Re: Make a New Field in QlikView

Make a New Field

rmdnkevin — Wed, 25 Nov 2020 16:16:04 GMT

Hi, everyone.

I have a field in main table like this :

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

Re: Make a New Field

MindaugasBacius — Mon, 09 Jul 2018 06:13:52 GMT

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?

Re: Make a New Field

nishanthi_8 — Mon, 09 Jul 2018 06:19:48 GMT

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

Re: Make a New Field

rmdnkevin — Mon, 09 Jul 2018 06:28:48 GMT

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

Re: Make a New Field

naddasandeep — Mon, 09 Jul 2018 06:36:17 GMT

You can use aggr function for the same like

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

Re: Make a New Field

nishanthi_8 — Mon, 09 Jul 2018 06:58:04 GMT

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

Re: Make a New Field

rmdnkevin — Mon, 09 Jul 2018 07:23:51 GMT

Thank you so much for the answer, it helps

Re: Make a New Field

rmdnkevin — Mon, 09 Jul 2018 07:24:15 GMT

Thank you so much for your response