topic Re: How to Pass a Listbox selected value into Dimension in QlikView

How to Pass a Listbox selected value into Dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guru's

I wanted to pass a Listbox selected value into Dimension to make the Comobo Chart dynamic. The field name is in a listbox filled by inline code. So far, no success.

Here is the example. The field name is Week NO and returns last six week week. When I pass the field name weekno using the list box the result is shows selected week only. But result is required last six week no.

Expected Result:

If Selected 10th week I should display the chart last week No(5,6,7,8,9,10)

If Selected 9th week I should display the chart last week No(4,5,6,7,8,9)

If Selected 8th week I should display the chart last week No(3,4,5,6,7,8)

How can I do it?

I created Dummy file.

Re: How to Pass a Listbox selected value into Dimension

sunny_talwar — Tue, 27 Sep 2016 16:20:07 GMT

Try using set analysis to achieve this

Sum({<WeekNo = {">=$(=Max(WeekNo)-5)<=$(=Max(WeekNo))"}>}A)

Sum({<WeekNo = {">=$(=Max(WeekNo)-5)<=$(=Max(WeekNo))"}>}B)

When 10 is selected

When 9 is selected

Re: How to Pass a Listbox selected value into Dimension

Thu, 29 Sep 2016 22:27:27 GMT

Hi Sunny,

Thanks you very much for your help. Sorry for the delay reply. My problem is solved

Thanks

Sharma Rajendra

Re: How to Pass a Listbox selected value into Dimension

Fri, 04 Nov 2016 11:06:34 GMT

Hi Sunny,

I applied above conditions in my reports.Some of the reports are working fine without any problem but one report is not working can you look into the below condition and let me know the issue.

Dimensions Field: =if([Week Number]>vMaxWeekMI-6,Date([Report Display Format],'DD - MMM'))

Expression Field conditions:

A= =count({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2015}>}INCNumber)

B= =count({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2016}>}INCNumber)

C = =timestamp(Sum({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2016}>}[Incident Calculation]) / count({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2016}>}INCNumber),'hh:mm')

D = =Sum({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2016}>}[Incident Calculation])

E = =Sum({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2015}>}[Incident Calculation])

Thanks

Sharma Rajendra