topic Re: Without expression table chart will work or not in QlikView

Without expression table chart will work or not

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

hello all,

I have requirement to show some of dimensions and there is one filed in dimension status,based on value i want to filter other fields in table.but without expression it is not showing values in table.can it be possible to show values without expression in table chart where status ='New'.This filtering iam not able to in table box.Please help me on same.

Thanks and regards,

kavitha

Re: Without expression table chart will work or not

arvind_patil — Thu, 31 Jan 2019 10:31:58 GMT

Hi,

Please add expression it also help you for sorting as well.

Thanks & Regards,
Arvind Patil

Re: Without expression table chart will work or not

anushree1 — Thu, 31 Jan 2019 10:38:50 GMT

Straight Tables do not let you have only Dimensions so one option is to add 1 as expression and hide 1(expression) using Hide colum in Presentation Tab

Re: Without expression table chart will work or not

pradosh_thakur — Thu, 31 Jan 2019 10:39:34 GMT

What if you hide it in the presentation tab? I have done it before in straight tables.

Re: Without expression table chart will work or not

marcus_sommer — Thu, 31 Jan 2019 16:30:44 GMT

In a table-chart you could also an expression like a dimension and adding a filter on it, for example with something like:

only({< Status = {'New'}>} FIELD)

- Marcus