Group by With Listbox

[#1]

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'

[MK_QSL]

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...

[#3]

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!!

[PrashantSangle]

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,

[tresesco]

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'

....