topic Re: Columns in table in QlikView

Columns in table

deepakqlikview_123 — Sat, 23 May 2015 12:44:31 GMT

Hi All,

Please sample QVw file.

I need to show HighRisk and LowRisk Only once instaead of showing in front of each row as shown in first chart.

when i am trying to do this as a last column i am getting high risk and low risk in front of each row as shown in second chart .

Can you please suggest how to get this result as a last column in pivot or straight table.

thanks

Clever_Anjos — Sat, 23 May 2015 13:04:06 GMT

Like this?

deepakqlikview_123 — Sat, 23 May 2015 13:08:35 GMT

Yeah but i want to show high risk and low risk only once instead of showing in front of each row in last column.

Thanks

deepakqlikview_123 — Sat, 23 May 2015 15:22:17 GMT

Hi All,

Can you please suggest on this.

Thanks

Clever_Anjos — Mon, 25 May 2015 11:36:02 GMT

Would you mind preparing a sample using Excel or other program? I´m not sure I´m following you

prajapatiamar38 — Mon, 25 May 2015 12:51:58 GMT

Hi,

Deepak Tibhe,I Don't think it is possible because the dimension you are putting first pivot table will group according to that dimension.

So if you want to show HighRisk and LowRisk only once you have to put that dimension first.

If it is possible please let me know,I also want to know this answer.

Thanks