Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
dennisnet
Valued Contributor III

Re: Urgent

Take a look at the attached Qlikview file.

I hope it is helpfull.

Good luck,

Dennis.

Not applicable

Re: Urgent

Hi Dennis,

It did help me out..

Thanks a lot

Zeeshan

Not applicable

Re: Urgent

Hi Dennis,

It did help me out..

Thanks a lot

Zeeshan

Not applicable

Re: Urgent

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

dennisnet
Valued Contributor III

Re: Urgent

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
Valued Contributor III

Re: Urgent

Don't forget "GROUP BY"...

Join (YourTable)

Load GradesID

          Sum(Values) as SumValues

Resident YourTable

GROUP By GradesID;

Not applicable

Re: Urgent

Hi Dennis,

Yes, it was helpful.

Thanks

Community Browser