topic Re: Need Help in QlikView

Need Help

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

Hi,

I have a table box with sample data like shown in below. If i select any filter left side or if i select any row that row should high late but the data should show remain same. for ex: if i select id=2 second row should high late data should display based on the selection but table box should not change. Can any one help on this?

Input
ID	Test	FirstOne	LastOne	NotSame
1	A	A	B	B11
2	A	A	C	C11
3	B	B	C	C22

Re: Need Help

dplr-rn — Thu, 15 Aug 2019 20:49:11 GMT

it wont be possible in table box.
you will need to move it into a Straight Table.
Use set analysis to ignore slections and you can use custom format cell to hightlight conditionally as well

Re: Need Help

sweety0912 — Fri, 16 Aug 2019 12:39:32 GMT

Thanks for reply!Can you please send me any sample qvw with that option?

Re: Need Help

dplr-rn — Fri, 16 Aug 2019 12:56:02 GMT

find attached a simple example

i have used a dummy expression with set analysis to ignore selection of ID and used background color expressions on all the dimensions.

Hope it helps

Re: Need Help

sweety0912 — Fri, 16 Aug 2019 13:35:21 GMT

I really appreciate your help!

But I am just using straight table to show the dimensions. I cant use the Sum({<ID=>}1) because it will sum up. Can you help me in this scenario?

Re: Need Help

dplr-rn — Fri, 16 Aug 2019 13:38:19 GMT

Just hide the column like i did in sample qvw.

or put one of your dimensions as expression e.g. Only({<ID=>}Test)

Re: Need Help

sweety0912 — Fri, 16 Aug 2019 13:54:37 GMT

Thank you very much!