topic Re: Display data conditionally in Table Box in QlikView

Display data conditionally in Table Box

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

Hi All,

How can i display data conditionally in Table box only. For example Dims are Year, Qtr and Month.

Condition should be Year =2016.

Thanks,

Nihhal.

Re: Display data conditionally in Table Box

zhadrakas — Wed, 04 May 2016 11:46:56 GMT

in Table Box you can use Conditional Show of the Table like:

If you want to Show columns via condition you have to use the table Chart object

Re: Display data conditionally in Table Box

Chanty4u — Wed, 04 May 2016 11:47:02 GMT

if(GetFieldSelections(Year)<>null())

if(GetFieldSelections(year)=2016)

Re: Display data conditionally in Table Box

marcus_sommer — Wed, 04 May 2016 11:48:09 GMT

Within a tablebox are no conditions possible (whereby a simply select of 2016 will be enough). But you could use a straight table for it which could be apply conditions.

Not very nice but possible would be you creates a flag on the year 2016 within your data and all other data for these flag are NULL - now you could include these flag-field into your table-box and enable for this field the hide NULL option within the tab presentation.

- Marcus

Re: Display data conditionally in Table Box

sunny_talwar — Wed, 04 May 2016 11:48:18 GMT

You can hide the whole text box object by using this condition

=SubStringCount(Concat(DISTINCT Year, '|'), 2016) = 1

Or you can show blank using this expression on the Main Tab

=If(SubStringCount(Concat(DISTINCT Year, '|'), 2016) = 1, YourExpression)

Re: Display data conditionally in Table Box

nihhalmca — Wed, 04 May 2016 11:49:50 GMT

Can we write this in Table box. I think it is not possible.

Re: Display data conditionally in Table Box

PrashantSangle — Wed, 04 May 2016 11:50:07 GMT

Hi,

use straight table.

Regards

Re: Display data conditionally in Table Box

sunny_talwar — Wed, 04 May 2016 11:51:48 GMT

Not to the table box object. But you can do it to Pivot or Straight table

Re: Display data conditionally in Table Box

jonathandienst — Wed, 04 May 2016 11:53:22 GMT

Is there a particular reason you wish to use a table box, rather than the more suitable straight table?

Re: Display data conditionally in Table Box

santiago_respane — Wed, 04 May 2016 12:03:08 GMT

If i where you i would do the following:

-Use straight table instead of table box

-Add all the fields you want to display as dimensions

-Add one expression with set analysis like this: =SUM({<Year={2016}> 1}

-In the presentation tab (straight table properties), hide the expression column created in the previous step

You will now have a table with your data filtered

Important: you can replace the hard-coded 2016 year in the expression with year(today(1)) or something like that to add some dynamism.

Please let me know if this helps.

Kind regards,

Re: Display data conditionally in Table Box

nihhalmca — Wed, 04 May 2016 12:12:41 GMT

Hi Jonathan - If i do with straight table have to hide measure. there is a way to create straight table without measure.

Nihhal.

Re: Display data conditionally in Table Box

sunny_talwar — Wed, 04 May 2016 12:16:18 GMT

You can hide columns in straight table on the presentation tab

Re: Display data conditionally in Table Box

avinashelite — Wed, 04 May 2016 12:22:24 GMT

table box doesn't allow you to write any expression , you need to write the conditions in the script and use the fields in front end

Re: Display data conditionally in Table Box

nihhalmca — Wed, 04 May 2016 12:42:26 GMT

Hi Santiago - Thanks for your response.

I want to do it in table box itself.

If i do with straight table there is a layout difference for example total row. (we can use hide colum however, still total row appear at top or bottom of table).

Hope you understand.

Nihhal.

Re: Display data conditionally in Table Box

PrashantSangle — Wed, 04 May 2016 12:53:34 GMT

Hi,

Use no Total in expression tab.

It will hide total of expression in Straight table.

Kind Regards,

Re: Display data conditionally in Table Box

Anonymous — Wed, 04 May 2016 13:04:03 GMT

in layout and give the condition at condtion Year=2016