topic Re: table box set analysis in QlikView

table box set analysis

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

Hi,

Is it possible to somehow do a type of set analysis in QlikView for a table box.

I want to display the fields as shown in the list below but I only want to include the ones where Activity equals 2 or 3. Where do I write the syntax (I think I know how to write that too but suggestions are always welcome)

Re: table box set analysis

sunny_talwar — Thu, 12 Apr 2018 09:08:17 GMT

You cannot use set analysis in table box object... alternative is to use straight table or some manipulation in the script to create a flag like this -> If(Match(Activity, 2, 3), 1) as Flag and then use this Flag in the table box with 'Omit When Where Field is NULL'

Re: table box set analysis

marcus_sommer — Thu, 12 Apr 2018 09:08:25 GMT

It's not possible within a tablebox but you could use a straight-table for it and implementing the condition in a dimension and enable then to hide NULL within this dimension, maybe something like this:

if(not match(Activity, 2, 3), StartDate)

- Marcus

Re: table box set analysis

Anonymous — Thu, 12 Apr 2018 09:19:49 GMT

Okay Thank you for your quick answer.

I find this weird since it's a simple sort function in excel and it's always hard to motivate using Qlik when things are easier in Excel

I'll look into your suggestion and see what I can do.

Re: table box set analysis

andrei_delta — Fri, 13 Apr 2018 13:55:20 GMT

Hi,

you can do these 2 things:

1. as you tried with Calculation Condition:

make a variable eg. vCondition = getfieldselections() (note: be careful to your selections cause it accepts more than one)

then go to table put condition: $(vCondition)='4' and when the value 4 isn t selected you will get a screen with calculation unfulfilled.

2. you can go table box properties -> layout - > conditional Show and put the condition ( $(vCondition)=4 ) there and the object disappears completely when the selected values doesnt corespond with the condition set.

Hope it helps,

Andrew