topic Re: Straight Table in QlikView

Straight Table

evansabres — Tue, 22 Mar 2016 14:28:49 GMT

Hello -

I am attempting to create a straight table that references a field named promoCDE from which there are several types of promoCDE's that I'd like to focus. I want my table to specifically only show the promoCDE's of

'ADULT'

'2FAMPK'

'HOLHAT'

'KIDDAY'

I'd assume I'd add a calculated dimension, but I cannot seem to get the syntax correct.

Re: Straight Table

Anonymous — Tue, 22 Mar 2016 14:31:31 GMT

Could you share the your calculated dimension with the syntax you suspect as dodgy ?

Although Set Analysis in your expression could be better.

Re: Straight Table

sunny_talwar — Tue, 22 Mar 2016 14:31:55 GMT

You can use calculated dimension, or set analysis.

1) Calculated Dimension

If(Match(promoCDE, 'ADULT', '2FAMPK', 'HOLHAT', 'KIDDAY'), promoCDE)

2) Set Analysis

{<promoCDE = {'ADULT', '2FAMPK', 'HOLHAT', 'KIDDAY'}>}

Re: Straight Table

Chanty4u — Tue, 22 Mar 2016 14:32:30 GMT

=Pick(promoCDE, '

'ADULT'

'2FAMPK'

'HOLHAT'

'KIDDAY')

Re: Straight Table

evansabres — Tue, 22 Mar 2016 14:40:35 GMT

The set analysis would only be used for an expression correct?

Re: Straight Table

Anonymous — Tue, 22 Mar 2016 14:41:44 GMT

Yup - Correct.