topic Re: Straight table scripting in QlikView

scripting

sunitha_chellaiah — Tue, 04 Sep 2018 05:29:39 GMT

Hi All,

I want to get below output using backend scripting.

Please use attached data to get the output.

Thanks.

Re: Straight table scripting

Arthur_Fong — Tue, 04 Sep 2018 05:46:19 GMT

Hi Sunitha,

Cant view your expected output.

Could you please re-upload again?

Thanks and regards,

Arthur Fong

Re: Straight table scripting

ecolomer — Tue, 04 Sep 2018 05:48:17 GMT

Can you explain a bit more your need?

Re: Straight table scripting

sunitha_chellaiah — Tue, 04 Sep 2018 06:22:56 GMT

I want below mentioned outputs using back end script only

Output 1: Sales_Amount with Region totals appearing below cities

Output 2: %age value of (Sales_Amount / Total Sales_Amount)

Output 3: %age value of (Sales_Amount / Total Sales_Amount) considering only region wise totals

All three output values to be achieved through back end scripting only. Only Sum() in front end to be used. Output should be calculate and acomodate if in case of new rows added
Use only Straight table. No Pivots. Only One dimension and three expressions to be used in the chart
Sorting of Regions and cities can be achieved with front end or even back end. But it should dynamically get sorted in case Regions or cities are increased within the data.

Re: Straight table scripting

ecolomer — Tue, 04 Sep 2018 06:39:04 GMT

Is that?

Re: Straight table scripting

sunitha_chellaiah — Tue, 04 Sep 2018 07:30:04 GMT

I want the output using straight table only

Re: Straight table scripting

manoj217 — Tue, 04 Sep 2018 07:49:57 GMT

can you please share your expected output clearly

Re: Straight table scripting

ecolomer — Tue, 04 Sep 2018 09:31:19 GMT

This?

Re: Straight table scripting

ksomosera10 — Tue, 04 Sep 2018 09:37:53 GMT

Hi Sunitha,

You can create a pivot table or straight table with the "City" as the dimension.

Then on the Expression, use the provided formula. The output should have (3) expressions for these:

Output 1: Sales_Amount with Region totals appearing below cities
Output 2: %age value of (Sales_Amount / Total Sales_Amount)
Output 3: %age value of (Sales_Amount / Total Sales_Amount) considering only region wise totals

You can then add then the compass as another dimension.

Thanks!

Re: Straight table scripting

sunitha_chellaiah — Tue, 04 Sep 2018 10:49:13 GMT

Output is correct. but i dont want to do any front end calculation. Simply i want to use sum() and only one dimension to be used.

Re: Straight table scripting

jonathandienst — Tue, 04 Sep 2018 10:54:01 GMT

May i ask why? It is possible, but the app will not respond in useful ways to user selections.

If you want partial totals, then a pivot table is the object to use. There are no subtotal in a straight table.

Re: Straight table scripting

Sergey_Shuklin — Tue, 04 Sep 2018 11:56:45 GMT

Hello, Sunitha!

Exactly as your output is:

All calculations are done in the script.

PFA.