# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Contributor

## Identifiers and Sparklines exclude each other?

Hi,

my Problem is as follows:

I have a straight table where the Dimension is KPI-ID.

Also, i have one expression where the formula is calculated by

```=pick(KPI-ID,
....,)

```

If i use identifiers like

```sum({1}SGMonat)

```

it works like it should -> SGMonat is calculated regardless of the selection.

So far so good.

Now, if i change this expression to show as a Sparkline it will stick to the actual selection, so the identifier isnt working.

What am i doing wrong?