Data operations

[#1]

Hello,

this is my issue i have this kind of data set :

I would like for each op calculate lthis expression q*price/sale and have this amount as a row of a table.

thanks for your help guys.

regards

[vishsaggi]

I got that, i am not sure why your script is not working. Hence asked for your sample app you are working on. Can you share the above sample app where you have those saleop, tvf,tdv etc fields coming from excel sheet?

[#3]

here you have my working data.

As you can see in the excel sheet the operation in qlik is not working.

Maybe my script has some issue. do you have any ideas?

thanks for your support.

[vishsaggi]

Is this your expected output you are looking for ? Any can i know why you are using that Forloop variable table script ?

[#5]

This is what i was expected  exactly.

For me the for loop allows to have the same opperation as an entry field

[vishsaggi]

I didn't get you, what you mean by same operation as an entry field? when you use for loop your data model has two separate tables like iSLAND tables?

[#7]

I mean that i need  the  data in the table  column sum(mnt_affe) to be a filed like a column of my original excel file.

[vishsaggi]

Try this and let me know if this is what you are looking?

Attached test_script.

[#9]

thanks for your support.

With this format , i can't make graphs with mnt_affre as axis. that is why i want mnt_affre as a field. that is why i used the scrpt.

[vishsaggi]

mnt_Affre is coming from the script right? As mentioned in your excel. So when you use a bargraph with Operation as Dim and Sum(Mnt_affre) as your expression it gives you the total sum of Mnt_affre? Is this not you are looking for, can you screen shot of your expected output with dimensions and what you need for expression? Sorry kind of hard to analyze what you are actually looking for?

[#11]

Sorry

I ment  sum(mnt_affre) as axis. when i put it in the script it makes an error. i want sum(mnt_affre) as a field, the amount in yellow in the screen shoot below