Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Urgent

Hi I am new to qlikview and do not have much knowledge about VB...So I am working on this dashboard where I am required to have an opening month and closing month. So, once I chose opening month say Jan and closing month say march. My dashboard should give me the difference between the various calculations like number of leavers/joiners in that time frame..

Can somebody help me with this?

7 Replies
Anonymous
Not applicable
Author

Take a look at the attached Qlikview file.

I hope it is helpfull.

Good luck,

Dennis.

Not applicable
Author

Hi Dennis,

It did help me out..

Thanks a lot

Zeeshan

Not applicable
Author

Hi Dennis,

It did help me out..

Thanks a lot

Zeeshan

Not applicable
Author

Hi Dennis,

There is one more thing i wanted to ask, I have created a table in qlikview which gives me the details like number of employees present their average salary etc..The mentioned information in the table is just picked up from the excel sheet. Now i want add these values and show it in the table itself. for example, there are 3 grades, each grade has a certain number of employees and adjacent to it their average salary. Now i want another row in the table which would give the sum of these values..

Can you help me with this

Thanks

Anonymous
Not applicable
Author

hi there,

If you want to do this in your script you can use Sum() and group by in your script;

something like

Join (YourTable)

Load GradesID

          Sum(Values) as SumValues

Resident YourTable;

This is just one option, I hope it is helpfull.

Good Luck,

Dennis.

disqr_rm
Partner - Specialist III
Partner - Specialist III

Don't forget "GROUP BY"...

Join (YourTable)

Load GradesID

          Sum(Values) as SumValues

Resident YourTable

GROUP By GradesID;

Not applicable
Author

Hi Dennis,

Yes, it was helpful.

Thanks