Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

creating a variable

Hi all,

I'm a very beginner user for the product, just a quick question,

I've a table showing item amounts and total cost for that specific line, I would like to show the unit cost for each item in each line dinamically just by dividing cost / unit amount.

Anyone can show me how the script supposed to be?

many thanks in advance.

1 Reply
manideep78
Valued Contributor

Re: creating a variable

Hi,

I didn't understood what you exactly need. I Imagined that you need this.

Add one more field with Calculation below:

Total_Cost/Item_Amount as Unit_Amount

If it doesn't work  its better to post your script or attach your qvw so that I can understand your problem and able to give much better solution.

Community Browser