topic Urgent in QlikView

Urgent

Mon, 25 Jun 2012 09:18:19 GMT

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?

Re: Urgent

Anonymous — Mon, 25 Jun 2012 09:32:07 GMT

Take a look at the attached Qlikview file.

I hope it is helpfull.

Good luck,

Dennis.

Re: Urgent

Tue, 26 Jun 2012 12:41:49 GMT

Hi Dennis,

It did help me out..

Thanks a lot

Zeeshan

Re: Urgent

Tue, 26 Jun 2012 12:42:04 GMT

Hi Dennis,

It did help me out..

Thanks a lot

Zeeshan

Re: Urgent

Thu, 28 Jun 2012 09:23:22 GMT

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

Re: Urgent

Anonymous — Fri, 29 Jun 2012 13:09:25 GMT

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.

Re: Urgent

disqr_rm — Fri, 29 Jun 2012 13:48:42 GMT

Don't forget "GROUP BY"...

Join (YourTable)

Load GradesID

Sum(Values) as SumValues

Resident YourTable

GROUP By GradesID;

Re: Urgent

Mon, 02 Jul 2012 06:25:05 GMT

Hi Dennis,

Yes, it was helpful.

Thanks