exclude function for dimension

[manoj217]

Hi all

I have a fields in straight table and i want to exclude some values in dimension dynamically.

fields like

A	B	C	count(A)
apple	red	3	1
ball	green	4	1
cat	yellow	3	1
dog	white	2	1
elephant	ash	5	1
fox	orange	1	1

now if i enter any value in input box it should not visible in the straight table

example :

if i enter apple,ball

it should not appear in the straight table

[manoj217]

your expression is giving count is correct only

but it is not hiding those values in the dimension

[jensmunnichs]

Hey,

It does hide those dimensions for me, as I demonstrated in pictures in my previous comments. Have you opened my .qvw and given it a try?

I think there might be a language barrier issue here, so I might just not fully understand your problem. Unless you give me a mockup of what your expected result(s) is/are, I'm not sure if I'll really be able to help you any further and someone else might have to give it a try...

[manoj217]

Sorry i didn't find any qvw kindly please share the file it would be helpful to me

[jensmunnichs]

Can you not see it under my comment(s)?

[manoj217]

Hi

For me it is not showing any attachment, so i didn't opened your file.

[manoj217]

Hi Jens,

i found the issue Your expression is working perfectly in mockup and expression count in my report

but the issue is i have some more expressions in the table so it is not able to hide those values

for your refference please add count( distinct A) you will find the issue

[jensmunnichs]

Welp, that's... weird. I'll try to attach the file to this comment again, don't really know what went wrong... If that still doesn't work, the only other way I can think of to get the file to you is a WeTransfer link: WeTransfer. The file will only stay on there for 7 days though, so if you want to keep it you'll have to save it to your pc.

Guess we could've solved this a lot quicker had I known you couldn't see my attachment... Oh well. If any moderators see this, I'm not sure if using WeTransfer is allowed, if there is a different way to add attachments that I'm not aware of, please let me know.

[Frank_Hartmann]

i guess manoj is looking to this conversation through his inbox. thats why he cant see the attachments.

@ Manoj: use this link to the thread. then you will be able to see the attachments:

exclude function for dimension

[jensmunnichs]

Did not know it worked that way, thanks Frank.

[manoj217]

PFA

when i add Count(distinct A) as another expression in the table it will not hide the values but count is showing correct