topic Re: Input box issue in QlikView

Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 07:44:33 GMT

Hi All,

jagan‌, tresesco‌, hic‌, swuehl‌, gwassenaar‌, maxgro‌

I have the details of year, no of students, students responded to the survey and their ratings in students table.

The requirement to have 4 input box filter to select minimum and maximum of no of students and the no of respondents to choose.

Please refer the below screenshot,

Based on the input box filters of minimum and maximum no of students and the no of respondents the expression should change in 'Test' table. Here my challenging is to handle the expressions when the value is not entered in any input box filter or entered in any of one or two or three. I have tried conditional view of expression based on the filter values, but as we have four filters the combination is 16 for each expressions.

It looks bit tedious. Could anyone please help me on this?

Please find the attached qvw and data...

Thanks & Regards,

Karthikeyan.

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 07:59:31 GMT

Hi TamilArasu‌

Please refer the test object in the dashboard. The Rating expression should change according to the values users enters in input box filter. The challenge is to make the expression flexible, since the user may or may not enter the values in all the input box.

Re: Input box issue

tamilarasu — Tue, 01 Dec 2015 08:38:33 GMT

Hi Karthikeyan,

I have tried and ended with nested If expression.

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 08:41:47 GMT

Could you please reply me the expression?

Re: Input box issue

tamilarasu — Tue, 01 Dec 2015 08:43:45 GMT

Attached.

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 08:47:23 GMT

Hi,

I have already completed this for no of students(vMinClass & vMaxClass) filter. But still the no of respondents (vMinResp & vMaxResp) also needs to be included in Average of rating expression.

Re: Input box issue

tamilarasu — Tue, 01 Dec 2015 08:50:12 GMT

I understood now.

Re: Input box issue

tresB — Tue, 01 Dec 2015 08:50:19 GMT

May be like attached sample

Sum({<Term={"=Sum([No of Students])>=$(vMinClass) and Sum([No of Students])<=$(vMaxClass)"}>}[No of Students])

Apply, input constraint (may be Integer) to handle the situation when nothing is entered.

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 08:59:02 GMT

Hi,

Thanks for your response.

you have considered only the first two input box values. we need to consider all four input box values in expression such as,

avg({<Term={"=Sum([No of Students])>=$(vMinClass) and Sum([No of Students])<=$(vMaxClass)

and Sum([No of Respondents])>=$(vMinResp) and Sum([No of Respondents])<=$(vMaxResp)"}>} Rating)

Re: Input box issue

tresB — Tue, 01 Dec 2015 09:02:08 GMT

That I thought you would be able to adjust accordingly. Are you stuck somewhere there?

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 09:05:26 GMT

Yes.

Say if the user doesn't enter value in all the input box and enters in one or two or three... the expression will not work.

That is the challenge I face here.

Re: Input box issue

tamilarasu — Tue, 01 Dec 2015 09:05:47 GMT

Try below,

= if($(vMinClass)=0 and $(vMaxClass)=0,sum([No of Students]),

sum({<Term={"=aggr(sum([No of Students]),Term)>$(vMinClass) and

aggr(sum([No of Students]),Term)<$(vMaxClass)"}>}[No of Students]))

Modify the responded and rating column accordingly.

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 09:07:55 GMT

Hi Tamil,

This would work for scenarios where the user enters the value in all filters or doesn't.

This expression will still fail if the user only enters the minimum value alone in both the filter.

Re: Input box issue

tresB — Tue, 01 Dec 2015 09:08:26 GMT

With integer constraints enabled, they would be treated as 0 (zero). Or, how do you want them to behave like?

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 09:40:55 GMT

Hi tresesco‌

I got your point.It worked

But ended up with the huge expression,

if(vMaxClass<>0 and vMaxResp<>0

,avg({<Term={"=Sum([No of Students])>=$(vMinClass) and Sum([No of Students])<=$(vMaxClass)

and Sum([No of Students responded])>=$(vMinResp) and Sum([No of Students responded])<=$(vMaxResp)"}>} Rating)

,if(vMaxClass<>0 and vMaxResp=0

,avg({<Term={"=Sum([No of Students])>=$(vMinClass) and Sum([No of Students])<=$(vMaxClass)

and Sum([No of Students responded])>=$(vMinResp)"}>} Rating)

,if(vMaxClass=0 and vMaxResp<>0

,avg({<Term={"=Sum([No of Students])>=$(vMinClass) and Sum([No of Students responded])<=$(vMaxResp)

and Sum([No of Students responded])>=$(vMinResp)"}>} Rating)

,avg({<Term={"=Sum([No of Students])>=$(vMinClass)

and Sum([No of Students responded])>=$(vMinResp) "}>} Rating))))

I can manage with this. Still if there any efficient way please let me know.. because I need to have 5 expression in the same chart few more calculation.

Thanks & Regards,

Karthikeyan.

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 09:52:48 GMT

Hi tresesco‌

I am bit confused with the set analysis...

Since we have only one dimension we have given as

Term={"=Sum([No of Students])>=$(vMinClass).

If we have more than one dimension, how can we handle the same?

Thanks & Regards,

Karthikeyan.

Re: Input box issue

tresB — Tue, 01 Dec 2015 09:58:34 GMT

For multiple dimensions, the dimension with more granularity should be considered in the set expression.

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 10:04:09 GMT

Sorry I am bit lost here.

How to amend the expression, if we have a dimensions as Term & Module..

Should it be as Module={"=Sum([No of Students])>=$(vMinClass)} ?

Thanks

Re: Input box issue

tresB — Tue, 01 Dec 2015 10:10:41 GMT

Set analysis doesn't work row-wise. However, you can restrict the rows from the chart at one go - and there dimensions wouldn't matter. Try with the same expression (with 'Term').

Re: Input box issue

karthikeyan1504 — Tue, 01 Dec 2015 11:48:47 GMT

Thank you so much...

Learnt bit more on set analysis.

Job done!!!