Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Take a look at the attached Qlikview file.
I hope it is helpfull.
Good luck,
Dennis.
Hi Dennis,
It did help me out..
Thanks a lot
Zeeshan
Hi Dennis,
It did help me out..
Thanks a lot
Zeeshan
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
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.
Don't forget "GROUP BY"...
Join (YourTable)
Load GradesID
Sum(Values) as SumValues
Resident YourTable
GROUP By GradesID;
Hi Dennis,
Yes, it was helpful.
Thanks