topic Re: Miscellaneos in QlikView

Miscellaneos

Fri, 20 Mar 2015 09:34:01 GMT

I have a data set. And I have created a table object in Qlkiview.

Can I use the same table's data, and do some Aggregate manipulations and use that data into a Chart ?

Thanks,
Praveen

Re: Miscellaneos

awhitfield — Fri, 20 Mar 2015 09:38:12 GMT

Yes, but you need to add more details to your posting, like what you are actually trying to achieve.

andy

Re: Miscellaneos

Gysbert_Wassenaar — Fri, 20 Mar 2015 09:39:51 GMT

A qlikview document contains a data model. You can see this data model using the Table Viewer (from the File menu). The fields from this internal data model can be used as dimensions and in expressions in sheet objects like Table boxes, pivot tables, bar charts etc. All the sheet objects will use the same data model. It's not possible to reference a chart or table box object in another sheet object. So yes, you can use the same data, but no you cannot reuse the calculated data shown in a table box or chart in another table box or chart.

Re: Miscellaneos

jyothish8807 — Fri, 20 Mar 2015 09:40:52 GMT

Yes you can Praveen. If you are applying aggregation functions in the script make sure to use group by.

Regards

Re: Miscellaneos

Fri, 20 Mar 2015 09:46:38 GMT

Sorry I didnt get your point. Can you please elaborate it more ?

Re: Miscellaneos

jyothish8807 — Fri, 20 Mar 2015 10:09:30 GMT

Hi Parveen,

if you use aggregation functions like sum, max in script, then you should use group by.

eg:

Load

Name,

sum(Salary) as Salary

from <>

group by Name;

Regards

Re: Miscellaneos

Fri, 20 Mar 2015 10:11:39 GMT

Thats fine.

But Can I do that aggregate function in a table and use those aggregated stuffs from the table object and use it in a chart ?

Thanks,

Re: Miscellaneos

jyothish8807 — Fri, 20 Mar 2015 10:40:05 GMT

Yes you can, in chart also you just have to create the same aggregated field, same as created in table.

It will be easy to explain if you can provide a sample question.

Regards

Re: Miscellaneos

buzzy996 — Fri, 20 Mar 2015 13:39:43 GMT

yes, u can do what ever with ur data.