Percentages in pivot table

[juliakhaa]

Hello all, I can not figure out how to correctly convert the value of the measure in %, as in the example of an Excel table, under the measure I take count(id), I would be grateful for help

I can’t use count(id)/count(total <week> id)

because week -> week(datecreated) & 'week' (' &WeekStart(datecreated) & ' - ' & WeekEnd(datecreated) & ')'

 

 

[vinieme12]

as below,

 count(id)/count(total <Status> id)

  WEEK is the ROW Dimension in the PIVOT TABLE   , then  count(TOTAL  <WEEK> Measure)  will return TOTAL FOR ALL ROWS 

  STATUS is the COLUMN  Dimension in the PIVOT TABLE   , then  count(TOTAL  <STATUS> Measure)  will return TOTAL BY COLUMNS 

[juliakhaa]

Yes, I realized that I need to use week, since it's not just a field, but -> =week(datecreated) & ' week (' &WeekStart(datecreated) & ' - ' & WeekEnd(datecreated) & ')'
It doesn't work in this case -> count(TOTAL  <WEEK> Measure)

[vinieme12]

Status is the field you need in this case  NOT Week

 count(id)/count(total <Status> id)

[juliakhaa]

But then I don’t get what I need 

 

[vinieme12]

Oops my bad,   you need to create a Week field in your DataModel, 

[juliakhaa]

Sorry, but how can I do this if my script is written in postgresql and this field for week is written in qlik

[vinieme12 · Accepted solution]

Use a preceding load , in the data load editor 

Your load script should be as below

Example 

Table name:

SQL 

Select X,y,z from somedbtable;

Add a preceding load as below 

Table name:

LOAD * , Week(Datefield) as week ;

SQL 

Select X,y,z from somedbtable;

Reference 

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/precedi...