topic graphic simple table in Qlik Automate

graphic simple table

Korto2024 — Wed, 15 May 2024 14:03:21 GMT

Hi ,

I have these data

Product;

load ID,annee,etat,Montant from table.qvd ;

the result is like this :

p1 2019 local 100

p2 2019 local 100

p3 2020 Importé 100

p4 2020 local 100

p5 2021 local 100

i want create a graphic simple table who deplay only the local product , Montant with sélection user

the list of local products :

HirisH_V7 — Wed, 15 May 2024 18:23:22 GMT

Could you please elaborate your issue more..

Korto2024 — Thu, 16 May 2024 17:25:40 GMT

Hi Hiris , thanks for the replay .

Yes I Can ,

so ,

I have the result of the load statement .

he result is like this :

Product Purchase Year Month purchase Purchase Type Purchase amount sale amount

p1 2019 01 local 100 150

p2 2019 01 local 100 130

p3 2018 02 Not local 100 120

p4 2019 03 Not local 100 90

p5 2020 02 local 100 111

In the Pivo table Chart

1- i want to display Only Product when (Purchase Type='Local') and thier amount whatever the selection user

exemple :

selection user : Year =2019 ,Month=01 the pivot table display Only P1, P2

2- in the pivot table , is there a way to add the amount cell above the calculated column?

thanks