topic Re: Filter Selection in QlikView

Filter Selection

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

Hi is there anyway i can have the Gross, Return, Total Disc, Net as selection. so user can click on the selection to display the data instead of all show at one table.
Example ,if user only wan to see Net, click Net, then the table only will show Net figure.

Re: Filter Selection

tharanikannan — Wed, 14 Nov 2018 03:57:20 GMT

Hi,

You can achieve this by checking "Drop down Select" option in presentation tab. Select the dimension and check the option. please find the screenshot for your reference below,

Thanks,

Tharani.

Re: Filter Selection

prabunakil — Wed, 14 Nov 2018 04:03:07 GMT

Hi my drop down is grey off.

Re: Filter Selection

tharanikannan — Wed, 14 Nov 2018 04:05:07 GMT

Hi,

I believe that, drop down selects are applicable for dimensions not for measures .

Re: Filter Selection

prabunakil — Wed, 14 Nov 2018 04:08:24 GMT

My Gross, Net, Return is expression. So how can i achieve that?

Re: Filter Selection

Anil_Babu_Samineni — Wed, 14 Nov 2018 04:13:22 GMT

Since These are 5 measures and effect to all Dimensionality. not sure the way is existing. But work around may be attachment.

Re: Filter Selection

prabunakil — Wed, 14 Nov 2018 04:31:28 GMT

Hi it did not work.

Re: Filter Selection

renuka_sasikumar — Wed, 14 Nov 2018 05:39:48 GMT

I hope I got your question.

You can create few buttons by setting a variable to it and apply conditional enabling in Expression.

For eg. if the user selects Net, it will show only Net Sales.

Hope this helps.

Regards,

Renuka S

Re: Filter Selection

prabunakil — Wed, 14 Nov 2018 06:09:36 GMT

Hi, do you have example. Yes this is the configuration i required.

Re: Filter Selection

renuka_sasikumar — Wed, 14 Nov 2018 06:25:31 GMT

Attached QVW FYI, Let me know if anything.

Regards,

Renuka S

Re: Filter Selection

prabunakil — Wed, 14 Nov 2018 06:26:57 GMT

Hi when i click net sales using ur QVW, the gross sales wont hide. is there any missing?

Re: Filter Selection

renuka_sasikumar — Wed, 14 Nov 2018 06:30:02 GMT

Are u talking about the Textobject which shows as GrossSales or the Measure in Chart?

Re: Filter Selection

renuka_sasikumar — Wed, 14 Nov 2018 06:33:48 GMT

Re: Filter Selection

prabunakil — Wed, 14 Nov 2018 06:38:26 GMT

can u share again the qvw file. coz when i press the button, it do not give ant result.

Re: Filter Selection

renuka_sasikumar — Wed, 14 Nov 2018 06:48:50 GMT

Its very simple create one variable vSelection,

use that in Button like

Then apply that in chart.

Hope this help

Re: Filter Selection

prabunakil — Wed, 14 Nov 2018 06:52:32 GMT

my qlikview version is qlikview 9.00. seems like different with urs.

Re: Filter Selection

renuka_sasikumar — Wed, 14 Nov 2018 06:54:20 GMT

Yes Mine is QlikView 12. Update it, Why using so old one.

Re: Filter Selection

prabunakil — Wed, 14 Nov 2018 06:55:21 GMT

is with license. i seems like cannot update it.

Re: Filter Selection

renuka_sasikumar — Wed, 14 Nov 2018 06:59:45 GMT

Download Qlikview November 2018 from here https://ap-a.demo.qlik.com/download/

U can go with desktop version, no license required. But you wont be able to my app.

Just follow the step which I have given in the above replies.

Create Variable
Set Variable in TextObject.
Apply condition in Chart Expression

Re: Filter Selection

prabunakil — Wed, 14 Nov 2018 07:02:00 GMT

if using Qlikview 9.0, how we can perform this one as per ur scren shoot.