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

HELP!!!!!!!!!!!!!!!!!!

Im really new to qlikView and I need to design a very complex chart and really need help,

Lets assume I have a table as below in excel file,

Person Name

Division

Desigination

Change date

Person AITEngineer1/1/2013
Person BITEnginer1/1/2013
Person AITManager2/2/2013
Person BITAsst Manager3/3/2013

So I want a chart in qlikview which would tell me how many Person from each division has got promotion? So the Chart should display as In IT Division 2 People have got promotion

26 Replies

Re: HELP!!!!!!!!!!!!!!!!!!

Here is an example, hope it helps

Not applicable

Re: HELP!!!!!!!!!!!!!!!!!!

When I open the qvw file which you have sent me I just see a table with a value 0 in it?

Not applicable

Re: HELP!!!!!!!!!!!!!!!!!!

hi

a:

LOAD p_name,

    count(p_name) as count,

     //division,

    // disig,

     max(date(date))

FROM

(ooxml, embedded labels, table is Sheet1)      Group by p_name;

sujeetsingh
Honored Contributor III

Re: HELP!!!!!!!!!!!!!!!!!!

Balu it is just as you can add a derived field as level and then you can easily do the ranking.

Re: HELP!!!!!!!!!!!!!!!!!!

this is the expression:

sum

(if(aggr(min(level),Division, [Person Name])<aggr(max(level),Division, [Person Name]),1,0))

the chart has two dimensions:

division and person name

the script is:

load

* Inline

[Person Name ,Division ,Desigination ,Change date

Person A,IT,Engineer,1/1/2013

Person B,IT,Engineer,1/1/2013

Person A,IT,Manager,2/2/2013

Person B,IT,Asst Manager,3/3/2013

]
;



left  Join



load * Inline

[

Desigination, level

Engineer,1

Asst Manager, 2

Manager, 3

]
;



However try to load data again in the file I sent to you

Not applicable

Re: HELP!!!!!!!!!!!!!!!!!!

I pasted the one which you gave me in QVW but What I see in the Bar chat is Person A and Person B and Division shows as IT but I also wanted to know From what Designation to what designation each person has changed. Also is it possible for you to explain me the expression?

Re: HELP!!!!!!!!!!!!!!!!!!

I've designed a chart flat table ...

So you would like a bar chart with person name and division, but how would you display the information of changing designation? Isn't better to show information with a table? Let me know

Not applicable

Re: HELP!!!!!!!!!!!!!!!!!!

I understand what you are saying but somehow I want to show this in a chart Im fine to show the chnage of designation in any chart not just bar so please help me

Re: HELP!!!!!!!!!!!!!!!!!!

I hope you can see the example, if not let me know, I've solved the problem

Hope it helps

Community Browser