topic Re: Straight table in QlikView

Straight table

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

Hi Community,

this is my table....

LOAD * INLINE [

Category, Product, Cost

A, A1, 100

A, A2, 200

A, A3, 300

B, BA, 400

B, AB, 500

];

My requirement...

When i making selection Category, in straight table i want to show full data but

Suppose if i am click Category A, only i want populate associate data for Category A. remaining should be Zero in straight table.

Thanks in Advance..

Re: Straight table

tamilarasu — Wed, 05 Oct 2016 04:44:49 GMT

Hi Paul,

Like attached.?

Re: Straight table

Anil_Babu_Samineni — Wed, 05 Oct 2016 04:57:30 GMT

I am not sure, what are you acheiving

But why not simply creation of Straight Table

Product - Dim

Cost - Expression

Then uncheck the suppress Zero-Values from Presentation tab and then choose Null Symbol "0" Then try.

Re: Straight table

paulwalker — Wed, 05 Oct 2016 04:59:57 GMT

it's very simple

Anyway thanks

Re: Straight table

rajpreeths — Wed, 05 Oct 2016 07:31:17 GMT

Hi Tamil,

Could you please share me how did you implement this ????

Br,

Rajpreeth S

Re: Straight table

tamilarasu — Thu, 06 Oct 2016 02:34:27 GMT

Hi Rajpreeth,

Goto dimenion tab and enable "Suppress When Value Is Null" and "Show All Values" options for the specific dimension. After that goto presentation tab and untick the "Supress Zero-Values" option. That's all.

I missed to explain this procedure in my previous post.

Re: Straight table

rajpreeths — Thu, 06 Oct 2016 05:48:27 GMT

Thank you Tamil