topic Re: Single button to select Miltiple Fields. in QlikView

Single button to select Miltiple Fields.

Vijesh — Tue, 15 Jan 2019 13:39:59 GMT

Hello,

How I can create a single button to select one or more fields. attached is the practice sheet. in the sheet there is description and months (Jan to Dec) are my field name. I want to create a button to select "Sep,Oct,Nov & Dec" and string value should be less than and equal to Zero.

** Please help me with a sample QVW file.

Thanks,

Re: Single button to select Miltiple Fields.

rwunderlich — Tue, 15 Jan 2019 15:56:50 GMT

Use "Select in Field" as your button action. Multiple values to be selected are separated by |. For the "Search String" value enter:

(Sep|Oct|Nov|Dec)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Single button to select Miltiple Fields.

Vijesh — Wed, 16 Jan 2019 05:50:19 GMT

This solution not working.

Re: Single button to select Miltiple Fields.

rwunderlich — Wed, 16 Jan 2019 06:48:21 GMT

Can you post an example of what you have tried?

-Rob

Re: Single button to select Miltiple Fields.

Vijesh — Wed, 16 Jan 2019 07:32:09 GMT

Please find the QVW and data File as attachment.

Re: Single button to select Miltiple Fields.

Gabriel — Wed, 16 Jan 2019 13:12:31 GMT

Hi,

The solution provided by Rob is right, what I think you need to add is transform your data. Using CROSSTABLE function. See below and attached script

// this is your original script loading from excel file
tmp:
LOAD Desctiption,
Jan18,
Feb18,
Mar18,
Apr18,
May18,
Jun18,
Jul18,
Aug18,
Sep18,
Oct18,
Nov18,
Dec18
FROM
Data.qvd
(qvd);

tmp1:

CrossTable(Month,Sales)
load * resident tmp;

drop table tmp;

Finaltb:
LOAD *, LEFT(Month,3) As [tmp_Month] RESIDENT tmp1;

drop Table tmp1;

In the UI, for the button to work use tmp_Month field in Select In FIeld then Search String = (Oct|Nov|Dec) .

Re: Single button to select Miltiple Fields.

Gabriel — Wed, 16 Jan 2019 13:12:35 GMT

Hi,

The solution provided by Rob is right, what I think you need to add is transform your data. Using CROSSTABLE function. See below and attached script

// this is your original script loading from excel file
tmp:
LOAD Desctiption,
Jan18,
Feb18,
Mar18,
Apr18,
May18,
Jun18,
Jul18,
Aug18,
Sep18,
Oct18,
Nov18,
Dec18
FROM
Data.qvd
(qvd);

tmp1:

CrossTable(Month,Sales)
load * resident tmp;

drop table tmp;

Finaltb:
LOAD *, LEFT(Month,3) As [tmp_Month] RESIDENT tmp1;

drop Table tmp1;

In the UI, for the button to work use tmp_Month field in Select In FIeld then Search String = (Oct|Nov|Dec) .

Re: Single button to select Miltiple Fields.

Vijesh — Thu, 17 Jan 2019 06:39:13 GMT

Hello Friend,

The solution you have given is of selecting Months as string. my requirement is of value as string and Fields should be multiple months. please find the attachment for the sample.

Thanks,

Re: Single button to select Miltiple Fields.

Gabriel — Thu, 17 Jan 2019 09:08:40 GMT

Hi,

Can I suggest that you expand your script to include a flag for values less or equal to Zero then in your UI the button that select the month should include another Select In Field FIELD = [Flag_SalesValue_LessOrEqualZero] AND VALUE = 1 . See below

// this is your original script loading from excel file
tmp:
LOAD Desctiption,
Jan18,
Feb18,
Mar18,
Apr18,
May18,
Jun18,
Jul18,
Aug18,
Sep18,
Oct18,
Nov18,
Dec18
FROM
Data.qvd
(qvd);

tmp1:

CrossTable(Month,Sales)
load * resident tmp;

drop table tmp;

Finaltb:
LOAD *, IF(Sales <= 0,1,0) AS [Flag_SalesValue_LessOrEqualZero] // check if sales or whatever fieldname this is less or equal to zero
;
LOAD *, LEFT(Month,3) As [tmp_Month] RESIDENT tmp1;

drop Table tmp1;

Re: Single button to select Miltiple Fields.

Vijesh — Sun, 20 Jan 2019 13:22:05 GMT

Thanks for the solution.