Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

how to show 2 (or more) values for one dimension?

Hi QlikFellaz,

I want to show on combo chart 2 dots for one value on dimension. Let's say that we have periods from 1601 until 1612. There are 2 values for 1610 and i want to show both values as a 2 dots.

Let's say that we have following data:

Field1     Period     Value

1             1610         5

2             1610         4

3             1609         6

4             1608         3

5             1607         1

6             1606         2

Like these two above. To achieve this i used two different expressions with set analysis (Field1 = 1 and Field1 = 2) but finally there will be many more so i want to find a solution which avoids creating too many expressions.

Thank you in advace,

Bartek

3 Replies
Highlighted

Re: how to show 2 (or more) values for one dimension?

Create One more expression for that and give Square use your expression as

Chr(10) & Chr(10) & Sum(Sales)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: how to show 2 (or more) values for one dimension?

Maybe switch to a scatter chart and use a synthetic dimension (serial #)?

For a combo chart, you'll have to define all your expressions somewhere, don't you? Or is it the same expression for all values?

Re: how to show 2 (or more) values for one dimension?

please post a sample application to demonstrate your issue.

thanks

regards

Marco