topic Re: Fetch multiple values from List Box in QlikView

Fetch multiple values from List Box

sagar_vij99 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am making a dashboard where i have to show comparison in performance numbers. I have a list box that has list of months and i have two container with same text boxes showing different numbers.

Now i want when someone selects a month, the numbers in one container should show numbers for the selected month and other container should appear for previous month.

Eg. if i select July the one container will show numbers for July other container should display numbers for June.

Sample expressions are '=sum(Headcount)' and " =num((($(Pro_T)+$(Qct))/$(Avt))*100,'##.00')&'%' ".

I tried using Set Analysis but could not achieve the same.

Can anyone help me out here. Any suggestion is appreciated..!!

Regards

Sagar

Re: Fetch multiple values from List Box

tresB — Wed, 30 Aug 2017 05:16:14 GMT

That could depend on many things like how you are creating month/date field in the script, how you are using the expression...Could you post a sample qvw that we can work upon and help you?

Re: Fetch multiple values from List Box

sagar_vij99 — Wed, 30 Aug 2017 05:21:16 GMT

I have made a separate table where i have listed all months and months number. i did this just to sort list box month wise. And field P_Month is synced with field in other tables.

So basically in the data also i am getting just the month name but not dates.

Month_Table:

Load * inline

[

P_Month,Month_num

January,1

February,2

March,3

April,4

May,5

June,6

July,7

August,8

September,9

October,10

November,11

December,12

];

Re: Fetch multiple values from List Box

tresB — Wed, 30 Aug 2017 05:25:14 GMT

Do you have data for multiple years or one year only? What your date field?

Re: Fetch multiple values from List Box

sagar_vij99 — Wed, 30 Aug 2017 05:29:02 GMT

I have data for multiple years. I do not have any field for date but yes i have columns for month and year named as P_Month and P_Year in all tables.

Re: Fetch multiple values from List Box

tresB — Wed, 30 Aug 2017 05:40:50 GMT

Create a new field as Month_Name in the transaction table like:

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Load

Headcount,

P_Month,

P_Year,

MonthName(MakeDate(P_Year, P_Month)) as Month_Name

From <>;

Then in the front end, try previous month expression, like:

=sum({<Month_Name={'$(=Monthname(Addmonths(Max(Month_Name),-1)))'}>}Headcount)

Re: Fetch multiple values from List Box

sagar_vij99 — Wed, 30 Aug 2017 06:05:20 GMT

I tried the solution but Month field has text values in it so i am getting '-' in the new column created. How should i handle it..?

Re: Fetch multiple values from List Box

tresB — Wed, 30 Aug 2017 06:10:10 GMT

Have you set the system variable setting I showed above? That should convert the full month names into proper month field. I guess now you should share your sample qvw to move forward.

Re: Fetch multiple values from List Box

sagar_vij99 — Wed, 30 Aug 2017 06:17:24 GMT

I have not got any option here to attach files. Advanced editor is also missing

Re: Fetch multiple values from List Box

sagar_vij99 — Wed, 30 Aug 2017 06:19:42 GMT

I do not mean to offend you but the set variable has 'monthnames' but we are not using the same name anywhere.

Re: Fetch multiple values from List Box

tresB — Wed, 30 Aug 2017 06:23:39 GMT

monthname() is a function and Month_Name is a field I used. And if you mean MonthNames at the top - that is a system variable defined at the very beginning you any application script.

Re: Fetch multiple values from List Box

sagar_vij99 — Wed, 30 Aug 2017 06:31:04 GMT

Now how can i share the qvw file then..?

Re: Fetch multiple values from List Box

tresB — Wed, 30 Aug 2017 06:33:41 GMT

If you don't see :

Then please contact: CommunityAdmin‌

Re: Fetch multiple values from List Box

sagar_vij99 — Wed, 30 Aug 2017 08:14:25 GMT

I can attach if i will post the question via community page directly. Shall i put it there.. Will it help you to get the file and check sol..?

Re: Fetch multiple values from List Box

sagar_vij99 — Wed, 30 Aug 2017 09:31:06 GMT

Hi,

I have attached the qvw file. In this file you wont find headcount field but instead of that we can use sum(Volume).

so lets keep the intent same.

Regards

Sagar

Re: Fetch multiple values from List Box

tresB — Wed, 30 Aug 2017 09:39:13 GMT

Try reloading the app with corrected statement like:

Load

MonthName(MakeDate(P_Yr, Month(Date#(P_Month&1,'MMMMY')))) as Month_Name

Re: Fetch multiple values from List Box

sagar_vij99 — Fri, 01 Sep 2017 06:31:51 GMT

Hey thanks for the reply.

I was just trying the above function and it is combining only June's month and year field.

when i removed &1 and Y from date# it is giving combos for all months.

Can you please explain what does &1 do and why above behavior is happening..?