topic Re: Chart- Straight table: Not all the Expression values (Corresponds to a dimension) are displayed. in QlikView

Chart- Straight table: Not all the Expression values (Corresponds to a dimension) are displayed.

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

I'm using a Chart (Straight table)- I have few Dimensions and few Expressions.

Now, If the values of the Dimensions are the same and corresponding expressions are different then I don't see those values:

For example:

Result should be like this:

Dimension_value Expression_value

05/01/2016 96103

05/01/2016 96105

05/03/2016 96103

05/03/2016 96105

05/05/2016 96103

But I get the result like this:

Dimension_value Expression_value

05/01/2016 -

05/03/2016 -

05/05/2016 96103

It combines values instead of displaying all values.

Do anyone have the solution for this?

Re: Chart- Straight table: Not all the Expression values (Corresponds to a dimension) are displayed.

sunny_talwar — Mon, 06 Jun 2016 19:40:13 GMT

You might need to add another dimension which makes the expression_value unique for each row. Do you have such a field available in your database?

Re: Chart- Straight table: Not all the Expression values (Corresponds to a dimension) are displayed.

Anonymous — Mon, 06 Jun 2016 19:58:40 GMT

Okay, I thought the same way! I need to find the unique key. Since We are building the table dynamically we don't need this "Expression value" always. So, I'm trying to find the uniquely value which applies for all possible column selections (Dynamic).

Is There any other way?

Re: Chart- Straight table: Not all the Expression values (Corresponds to a dimension) are displayed.

Qrishna — Mon, 06 Jun 2016 20:00:40 GMT

Do the Dual Function in your script.See attached.

Output:

Re: Chart- Straight table: Not all the Expression values (Corresponds to a dimension) are displayed.

Anonymous — Mon, 06 Jun 2016 20:15:28 GMT

This is a good idea too.. Thanks

Re: Chart- Straight table: Not all the Expression values (Corresponds to a dimension) are displayed.

Qrishna — Mon, 06 Jun 2016 20:56:56 GMT

If you dont have any unique key, you can use dual function else usage of unique key is preferred.