topic Re: Group by With Listbox in QlikView

Group by With Listbox

Mon, 01 Sep 2014 13:35:38 GMT

H All

I have a requirement.

I want to give the field in Listbox and whenever the user select any value from listbox then the chart data will groupby on basis of selection made in listbox.

Eg:::

ListData:

LOAD * Inline [

SNo, Data

1, Task

2, Project Type

3, User

];

Chart is showing data with time.

Now when user select Task from listData then chart will be groupby 'Task'

Re: Group by With Listbox

MK_QSL — Mon, 01 Sep 2014 13:39:08 GMT

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table

Is this what you are looking for?

If not, please provide sample data along with your requirements in excel file...

Re: Group by With Listbox

Tue, 02 Sep 2014 06:25:48 GMT

That post is all about adhoc report with Table.

I was looking for groupby with listbox data. That is done with Aggr() in expressions.

Thanks!!

Re: Group by With Listbox

PrashantSangle — Tue, 02 Sep 2014 06:30:29 GMT

Hi,

You can use Variable to acheive desired requriement.

Create Variable->assign fieldselection value.

and use that variable in Aggr()

Hope this will solve your issue.

Regards,

Re: Group by With Listbox

tresB — Tue, 02 Sep 2014 06:38:46 GMT

Do you have fields like 'Task', 'Projects Type', 'User' ? If yes, you might want to use conditional enablement of dimensions to achieve that.

Dimension: Task

Enable Conditional :=Data='Task'

Dimension: [Projects Type]

Enable Conditional :=Data='Projects Type'

....