Visual tab

[Stefano2]

Hi all,

please could you tell me what is the script in qlik sense to use the sumifs Excel formula?

so, to obtain A= 2, B=7, C= 5?

Category	Month	Values
A	Jan	0
A	Feb	2
A	March	0
B	Jan	1
B	Feb	1
B	March	5
C	Jan	0
C	Feb	0
C	March	5

[abhijitnalekar]

Hi @Stefano2 ,

Do you want to show the Category values in the KPI then you can use the below expressions

sum({<Category={'A'}>}Values) for A

sum({<Category={'B'}>}Values) for B

I hope I have understood the requirement correctly.

[AshutoshBhumkar]

Hello,

What exactly do you want to achieve ?

Are you trying to show this data in Table ? Then Dimension as Category and Measure as Sum(Values) will sum all the values for respective Categories.
or

You want to create the resulting table in script ?

Thanks,

Ashutosh

[Stefano2]

Thanks,

but if I have a lot of categories and not only A,B,C how can i manage it?

Thanks a lot

[Stefano2]

I would create a second table like the table below?  

How can  I do it?

Category	Values
A	2
B	7
C	5

Thanks a lot

[AshutoshBhumkar]

If you are trying this table on straight table.

Dimension : Category, Measure : Sum(Values)

For script, you need to use group by clause like below

Load

Category,

Sum(Values) as Values

From[...............]

Group by Category;

[Stefano2]

But that script works even if i m working in a visualization tab? 

Because it doesn't accept functions like Load or Group by

[AshutoshBhumkar]

You can use MultiKPI chart in that case.

Check out below link.

https://www.youtube.com/watch?v=OTlAw9YSpWo

[2.26]

[AshutoshBhumkar]

Load and Group by clause are for Scripting in Qlik sense.

Create a Straight Table->Add Dimension Category->Add Measure Sum(Values)

You will get below output.

Category	Values
A	2
B	7
C	5

[Stefano2]

is it possible in qlik sense the move or copy a table created in the visualization area to the data manager ? or the the data manager can be populed only by external files ?

Thanks for the help