topic Re: requirement on Straight Table in QlikView

requirement on Straight Table

Wed, 25 Nov 2020 16:16:04 GMT

i have created a straight table in that based on conditions i have filled colors in fields but my issue is i have to show the data like below image please find the image.is that possible please help me out on this.

Thanks

Re: requirement on Straight Table

Clever_Anjos — Fri, 17 Jun 2016 18:13:33 GMT

Yes you can

Use a pivot table and transpose the dimension

So use a background color to change the color

Re: requirement on Straight Table

Fri, 17 Jun 2016 18:24:50 GMT

here i have field names .please find that image find sample data

Here in my sample data name is Dimension and based on starts and ends i wrote conditions it works fine.now my issue is how to associate field name with this chart

Note: we need to make all the field names into one field

Thanks

Re: requirement on Straight Table

Clever_Anjos — Fri, 17 Jun 2016 18:36:19 GMT

Not sure what you really need, would you mind prototyping into Excel the final result you need?

Re: requirement on Straight Table

Fri, 17 Jun 2016 18:41:41 GMT

is that possible to convert field names into filed values with association?

Re: requirement on Straight Table

Clever_Anjos — Fri, 17 Jun 2016 18:42:09 GMT

Do you know the $Field expression?

Put this into a pivot table, please

Re: requirement on Straight Table

Fri, 17 Jun 2016 19:04:26 GMT

assume ..Anjos.now i need to remove some fields from it .is that possible?

Re: requirement on Straight Table

Fri, 17 Jun 2016 19:06:13 GMT

Assume...Anjos it is working but i need to remove some field names from it.Is that possible?

Re: requirement on Straight Table

Clever_Anjos — Fri, 17 Jun 2016 19:11:26 GMT

Use If( Index('City, Country', $Field), $Field)

and put into that list the names you need/want

Re: requirement on Straight Table

Clever_Anjos — Fri, 17 Jun 2016 19:11:59 GMT

And check "Supress When Value is Null "