Discussion Board for collaboration related to QlikView App Development.
Hello everybody, I'm very new to Qlikview and I'm trying to solve one problem for couple day but still stay clueless.
I have a table:
In the end of all I need a table that will look like this:
Could you suggest any options for doing this?
I'm downloading data from the DB, first I've tried pivot table but its not working as I need, maybe I need to use some expressions or smth.
Thank you in advance!
Thank you very much for your help! Could you please explain me how to put all the group names on top, when I'm creating a pivot table they used to appear on the left column..
I still have problems, maybe because my example table is easier then actual one in qlikview.
In my actual pivot table I'm using two dimensions Last_name and Sales_group_name and I'm also using and expression that calculates sum(points). I'm draging fields but still don't have desirable result.
Attach your sample app, we can do it for you.
If not possible, hold salescript_group_name and drag that to top right upper hand corner.
YEY! It finally changed!!! Thank you a lot! Sorry I can't send you application now coz I'n working in QlikView via RDC
Could you also help me with one more thing, how to add to this table Total column from the right side?
P.S. could I add you in Skype or smth?
Thats amaizing!!! Thank you so much!
I'm embraced now but could you also tell me how to make in this table sorting by date or maybe better to create a list with dates apart from the table or use slider for this purpose?