topic Re: Getcurrentfield() not finding group in QlikView

Getcurrentfield() not finding group

Mon, 16 Mar 2015 20:48:41 GMT

Hey There,

I created a drill down group called "QuestiontoResponse" in the Edit Groups section of the dimension tab.

However when I go to the expressions tab and attempt to call the group after I've inserted the getcurrentfield function this group (or any group) does not appear as an option to insert into getcurrentfield().

I've make sure that I am using my group as my dimension thinking that the expression will only allow the currently used dimension, but that has not helped either. When I insert the string "QuestiontoResponse" into the function, QlikView returns the "Error in Expression" Message.

Does anyone know why this could be happening?

Re: Getcurrentfield() not finding group

fred_s — Mon, 16 Mar 2015 21:03:21 GMT

Hi Briana,

Same red error in expression.. but it works, at least in my testfile (used it as Window title).

There are some situations in Qlikview where you get errors like this, while the code is good (or at least accepted :-).

Maybe this is one of them.

Grtz. Fred

Re: Getcurrentfield() not finding group

Mon, 16 Mar 2015 21:34:11 GMT

Hi Fred,

Thank you! Just ignoring it did work. But now I'm facing an additional problem. I'm not sure if this stems from not understanding the function or if I should be using a nested if statement instead.

My drill down group has two fields: "mini_sheet_label" and "mini_student_response", so I wrote my expression as follows:

Essentially, without getting into what the original table looks like I just want if the dimension is mini_sheet_label I want the data to display as the first expression, and if the field is mini_student_response I want the data to show as the second expression.

I know the second expression displays the data correctly because I made a graph on the side that just has that expression and dimension, but when I drill down only the test graph(left graph) shows the correct data.

Do you know how I can update my expression to get both graphs to match?

Thanks again,

Briana

Re: Getcurrentfield() not finding group

fred_s — Mon, 16 Mar 2015 21:50:41 GMT

Hi Briana,

Is it top secret or is it possible to share your file?

And/Or share the complete expression and show me some values for

mini_sheet_label, mini_student_response, Mini_subject, Mini_Interim_Points

and the fields part of your Drilldown group.

Re: Getcurrentfield() not finding group

Mon, 16 Mar 2015 22:29:41 GMT

I unfortunately can't share the file, this data is for our school district and I'm hesitant to share out our student data. However all of the data for this dashboard comes in from a single table which I have attached here. I've only included the data for the test and question that I've been using as my guinea pig.

The test is titled 02.27 Grade 7 SOC Quiz 1, and I'm looking at the data for all the students tested for question #7.

The percent of students that got #7 correct was 67.% and the count of the responses is in the table below.

responses	student_response
2	NULL
31	A
27	B
161	C
19	D

The complete expression for the drill down chart is:

=if(GetCurrentField(QuestiontoResponse) = 'Mini_Sheet_Label'

,sum({$<Mini_Subject ={'SOC'}>}Mini_Interim_Points)/count({$<Mini_Subject ={'SOC'}>}Mini_Interim_Points)

,count({$<Mini_Subject ={'SOC'}>}Mini_Student_Response))

The dimensions and expressions for the side chart are:

Dimension: Mini_Student_Response

Expression: count({$<Mini_Subject ={'SOC'}>}Mini_Student_Response)

Let me know if I can supply anything else.

Re: Getcurrentfield() not finding group

fred_s — Mon, 16 Mar 2015 23:48:17 GMT

In my dataset there's just one value in mini_sheet_label and it's 7.

If it's the same in your set, the Drilldown Group will automatically Drill down to the next level, since the first dimension only has one value.

Grtz. Fred

Re: Getcurrentfield() not finding group

Tue, 17 Mar 2015 01:30:11 GMT

Yup, and that's what I want, but I want to see the distribution of student responses when I drill down, so I want the top graph to look like such:

And the drill graph, when I choose number 7 to look like:

Re: Getcurrentfield() not finding group

fred_s — Tue, 17 Mar 2015 08:48:34 GMT

Hi Briana,

It worked for me and I have used your expression.

One thing: Qlikview is Case sensitive...

I had to adjust a couple of fieldnames.

If it's not working, I'd suggest to take a look at the capitals.

Re: Getcurrentfield() not finding group

Tue, 17 Mar 2015 17:08:03 GMT

Interesting! Gotcha, I'll keep at it, thanks so much for all of your help!

Briana

Re: Getcurrentfield() not finding group

fred_s — Tue, 17 Mar 2015 18:58:10 GMT

Hi Briana,

If your question is answered, please mark it as answered.

Means also that people who are trying to help others, don't have to put energy in this thread any more 😉

Thanks

Re: Getcurrentfield() not finding group

Tue, 17 Mar 2015 19:50:36 GMT

Unfortunately, I’m still encountering the problem. I’m continuing to troubleshoot and once I’ve found a solution I will make sure to post on the thread and publish my solution.

Thank you again for all of your help!

Briana

Re: Getcurrentfield() not finding group

fred_s — Tue, 17 Mar 2015 21:44:33 GMT

Hi Briana,

Okay, fair, in that case I'll give it another try, another approach.. see attachment

(but first make sure you get your capitals right 🙂

Btw, I've changed your data to get 9 Question numbers.

Grtz.

Fred

Re: Getcurrentfield() not finding group

Tue, 17 Mar 2015 22:13:42 GMT

Finally figured it out. I had set my max value to a static max of 1. When I removed that both charts rendered correctly.

Thanks Fred!