topic Re: How to use searchable expression for a straight table having multiple conditional dimension in QlikView

How to use searchable expression for a straight table having multiple conditional dimension

Tue, 03 Jan 2017 10:00:37 GMT

Dear All,

I have a straight table.Where multiple conditional dimensions i.e-Selecting a/multiple dimension(s) the table will be generated .Now I have some expressions.I want to use searchable option on the expressions so that the user can input a condition(>1000) ,on their input the output will be reflected in those expressions.

Please help.

Re: How to use searchable expression for a straight table having multiple conditional dimension

marcus_sommer — Tue, 03 Jan 2017 12:02:19 GMT

Do you want to filter the table to the results of the expressions? Then you will need listbox-expressions like these:

aggr(sum(Value), Dim1, Dim2)

or maybe

class(aggr(sum(Value), Dim1, Dim2), $(vBucketSize) /* maybe 1000 */)

- Marcus