jQWidgets Forums

Forum Replies Created

Viewing 15 posts - 46 through 60 (of 144 total)

← 1 … 3 4 5 … 10 →

Author

Posts
October 2, 2015 at 8:29 am in reply to: Theme Builder: pinned value which setting (aggregates, filterrow) Theme Builder: pinned value which setting (aggregates, filterrow) #76366

Klaus H
Participant

Hello Vladimir,

thank you for the response, I totally missed the explanation.

Best Regards
Klaus

September 30, 2015 at 6:12 am in reply to: Dropdown with checkboxes and commaseparated display Dropdown with checkboxes and commaseparated display #76295

Klaus H
Participant

Hi ivailo,

thank you for the quick response.

Best Regards
Klaus

September 25, 2015 at 6:30 am in reply to: Calculationg in aggregates Calculationg in aggregates #76174

Klaus H
Participant

Just to share my solution for the rest:

I simply used JavaScript variables that I defined outside of the grid for this. Initialize them with zero, building the sum in aggregates custom function and then accessing the variables in the aggregates renderer, calculate the percent and then display the result. And then of course reset the variables back to zero.

Best Regards
Klaus

September 23, 2015 at 7:05 am in reply to: Calculationg in aggregates Calculationg in aggregates #76090
Klaus H
Participant
Hello Peter,

I understand these examples, but they all do something different than what I want to do.

Here’s an example, I mofidied the the second example:
```
<!DOCTYPE html>
<html lang="en">
<head>
    <title id='Description'>In this sample is demonstrated how to customize the rendering of the Grid's aggregates.</title>
    <link rel="stylesheet" href="../../jqwidgets/styles/jqx.base.css" type="text/css" />
    <script type="text/javascript" src="../../scripts/jquery-1.11.1.min.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxcore.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxdata.js"></script> 
    <script type="text/javascript" src="../../jqwidgets/jqxbuttons.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxscrollbar.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxmenu.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxgrid.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxgrid.edit.js"></script>
    <script type="text/javascript" src="../../jqwidgets/jqxgrid.selection.js"></script> 
    <script type="text/javascript" src="../../jqwidgets/jqxgrid.aggregates.js"></script> 
    <script type="text/javascript" src="../../jqwidgets/jqxcheckbox.js"></script>
    <script type="text/javascript" src="../../scripts/demos.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {            
            var data = [{"id": 1, "amount": 100, "percentchange": 5, "result": 105}, {"id": 2, "amount": 200, "percentchange": 3, "result": 206}, {"id": 3, "amount": 75, "percentchange": 8, "result": 81}, {"id": 4, "amount": 90, "percentchange": 4, "result": 93.6}, {"id": 5, "amount": 200, "percentchange": -4, "result": 192}]

            var source =
            {
                localdata: data,
                datatype: "json",
				id: "id",
                datafields:
                [
                    { name: 'id', type: 'number' },
                    { name: 'amount', type: 'number' },
                    { name: 'percentchange', type: 'number' },
                    { name: 'result', type: 'number' }
                ]
            };

            var dataAdapter = new $.jqx.dataAdapter(source);

            // initialize jqxGrid
            $("#jqxgrid").jqxGrid(
            {
                width: 850,
                source: dataAdapter,                
                showstatusbar: true,
                statusbarheight: 50,
                showaggregates: true,
                columns: [
                  {
                      text: 'Amount', datafield: 'amount', width: 190, cellsalign: 'right', cellsformat: 'd', aggregates: ['sum']
                  },
                  {
                      text: 'Change (%)', datafield: 'percentchange', width: 190, cellsalign: 'right', cellsformat: 'd'
                  },
                  {
                      text: 'Result', datafield: 'result', width: 190, cellsalign: 'right', cellsformat: 'd', aggregates: ['sum']
                  }
                ]
            });
        });
    </script>
</head>
<body class='default'>
    <div id='jqxWidget'>
        <div id="jqxgrid"></div>
    </div>
</body>
</html>
```
If you run this example, you see I have three columns I display, an amount, a change via percent and than the amount after the change. I use aggregates to show the sum of the two amount columns which result in 665 and 677.6. Now I want to calculate the resulting percent change for the two sum values with the formula 677.6/665*100-100 resulting in 1.89473684. But is it possible to do this calculationin an aggregatesrenderer and if so, how do I get to the two values?

Best Regards
Klaus
September 22, 2015 at 3:34 pm in reply to: Calculationg in aggregates Calculationg in aggregates #76074

Klaus H
Participant

I think I see it now, it’s in the aggregates property of the custom aggregates in the Price column?

That seems to take each value of the rowand adds it up to the aggregate, I need in a aggregate field calculation the value of two other aggretage sums. I’ll try to build an example and get back to you.

September 22, 2015 at 3:28 pm in reply to: Calculationg in aggregates Calculationg in aggregates #76073

Klaus H
Participant

Hello Peter,

thank you for your answer and for the good news, unfortunately I don’t see that feature in any of the 3 aggregate examples. Could you please give me a pointer in the right direction? I’d appreciate that very much.

Best Regards
Klaus

September 16, 2015 at 10:31 am in reply to: column type button with condition column type button with condition #75907

Klaus H
Participant

Hello Peter,

thank you for the feedback, I will have to find another way then and already have an idea.

Regards
Klaus

September 16, 2015 at 10:02 am in reply to: column type button with condition column type button with condition #75902

Klaus H
Participant

Hi Peter,

the customer wants a button in the look of the theme there. Since posting I have tried to achieve this via a normal cellsrenderer – creation of the button works fine, but making it into a jqxButton with a theme does not work, because the buttons are not there, when the rendered callback of the grid is invoked.

Any ideas?

Regards
Klaus

July 6, 2015 at 11:09 am in reply to: showTimeButton without AM/PM showTimeButton without AM/PM #73389

Klaus H
Participant

Hi,

thanks for the response, upcoming versions will be fine. AM/PM is not common in Europe, so this would confuse users right now.

Kind Regards
Klaus

June 17, 2015 at 7:57 am in reply to: Problem: rowdetail with Copy & Paste Problem: rowdetail with Copy & Paste #72620

Klaus H
Participant

Hello,

I just wanted to add that after discovering in the fiddle example that copy and paste via right mouse click work, in the mask where I need copy and paste to work, there is a context menu on the grid, so right mouse click would not work to paste something into it.

I have adjusted the fiddle so it also has a context menu in the rowdetail grid.
http://jsfiddle.net/7uc7rqpb/2/

Regards
Klaus

June 16, 2015 at 1:26 pm in reply to: Problem: rowdetail with Copy & Paste Problem: rowdetail with Copy & Paste #72587

Klaus H
Participant

Hello,

as I said, it is not possible to copy or paste values in/from File and File path columns. I can edit them meaning I can overwrite the value, I can delete the value and I can add characters to the value.

What I cannot do is having text in the clipboard, going in one of the two mentioned columns and paste it in there or mark text in one of the two columns and copy it. To be precise I tested it with CTRL+C and CTRL+V and that does not work, clicking in the field with right mouse click and selecting copy/paste works. But I need a solution with the keyboard shortcuts, that should also work in my opinion.

Regards
Klaus

February 3, 2015 at 9:13 am in reply to: Integrating in existing form Integrating in existing form #66405

Klaus H
Participant

Hello Peter,

thank you.

Kind Regards
Klaus

February 3, 2015 at 8:49 am in reply to: Integrating in existing form Integrating in existing form #66401

Klaus H
Participant

Hello Peter,

I did not question that. I understand what the widget is supposed to do. It takes a div, adds a button, a container, an iframe and a form with an file upload field. This is good when you need to upload a file, period. As I mentioned above this is seldom the case when I have to upload a file and store it on a server or in a database, for that I need additional data I have to send with the file. So it usually is a form with multiple input fields (jqxInput, jqxNumberInput, jqxDropDownList, …). So on the server side I have a script/servlet that expects the files and all the other parameters. I don’t see a way to achieve this with this widget because as far as I can tell this widget is meant for only the file to be submitted, hence the generated form.

For me it would be a huge benefit to have a form with multiple fields including a file upload field to use a theme setting and submit the form including the file upload and be able to validate it with jqxValidator – that would be perfect. And since you have a layout for the file upload now, my question in general is would it be possible with an additional widget to transform a div into the button, the container and the file upload field without adding a form into it (= only single file upload).

So in general it would only be a visual upgrade from the standard file upload field. From the look and feel of forms it would be a huge benefit.

Kind regards
Klaus

December 4, 2014 at 7:34 am in reply to: Range Selector with several dataFields? Range Selector with several dataFields? #63771

Klaus H
Participant

Hi Peter,

thank you for the answer.

Kind regards
Klaus

November 25, 2014 at 3:50 pm in reply to: Breaking Change 3.6.0 Breaking Change 3.6.0 #63299

Klaus H
Participant

Hello Peter,

thanks for the clarification. I thought it had something to do with chart and the scope of the selection maybe, but since I do not use AngularJS I understand why I did not get the meaning.
Author

Posts

Viewing 15 posts - 46 through 60 (of 144 total)

← 1 … 3 4 5 … 10 →