topic Consider min value in Input box in QlikView

Consider min value in Input box

nakuldev — Sat, 16 Nov 2024 05:03:21 GMT

Hi All,

I have a requirement where, "One lab with one workshop, show the exact value. One lab with two workshop, show the minimum value. No lab or multi lab volume = 0"

I wrote the below logic and One lab with two workshop, show the minimum value logic is getting failed. Could someone help me with this issue. PFA the excel source file.

=if(GetSelectedCount ([LAB ID]) <> 1,0,
if(GetSelectedCount ([LAB ID]) = 1 and GetSelectedCount (Workshop) > 1,(aggr(([VOLUME/HOUR] * [EER/HOUR] * sum(Data)),[LAB ID],Workshop,MachineFamily_Name)),
([VOLUME/HOUR] * [EER/HOUR] * sum(Data))))

Thanks in Advance

Dev

Re: Consider min value in Input box

tresB — Wed, 05 Dec 2018 06:56:23 GMT

Could you share your qvw with sample data where it shows how/what exactly you are trying to get?

Re: Consider min value in Input box

nakuldev — Wed, 05 Dec 2018 07:06:24 GMT

Hi Tresesco,

I did few changes to the expression but still getting issues with "MY" region.

PFA the sample qvw.

Thanks

Nakul Dev

Re: Consider min value in Input box

tresB — Wed, 05 Dec 2018 07:09:34 GMT

Thanks for sharing the app. Please help telling where should I look at (chart/text box). What would be the expected output ?

Re: Consider min value in Input box

nakuldev — Wed, 05 Dec 2018 07:20:03 GMT

Hi Tresesco,

PFA the Filters image.

In filters apply one LAB ID and select both the WORKSHOPS the the VOLUME at the left bottom should show the minimum value instead combining both. Pls refer to the expression in QV(Vvolume variable) and excel attached earlier for reference

Re: Consider min value in Input box

tresB — Wed, 05 Dec 2018 09:09:31 GMT

Min, which min? Could you tell me the right number for you for two selected workshops? And how do you calculate that? I am asking this because, I think there is a possibility of improvement in your expression.

Re: Consider min value in Input box

nakuldev — Wed, 05 Dec 2018 11:12:42 GMT

In the image attached, the yellow highlighted are the values(min) need to be displayed.