topic Re: Take off from table in QlikView

Take off from table

Anonymous — Fri, 14 Sep 2012 19:36:57 GMT

Hi,

I would like to add following condition: check if any particular client has less that N (variable that I enter) records in any given month, and then take off this client from the table completely.

Please see my attached file.

Thanks,

Re: Take off from table

Fri, 14 Sep 2012 19:39:28 GMT

Here you go.

Re: Take off from table

Anonymous — Fri, 14 Sep 2012 19:44:00 GMT

Cool!!!

Thanks,

Re: Take off from table

Anonymous — Fri, 14 Sep 2012 20:34:44 GMT

Hi again,

I find out it doesn't work as I want. It removes only in this month.

You can check it, if you select small number like 5, 10. It keeeps this client, but hides in month.

Cheers,

Re: Take off from table

Anonymous — Mon, 17 Sep 2012 17:57:34 GMT

Any ideas???

Re: Take off from table

Mon, 17 Sep 2012 19:00:56 GMT

What result are you expecting to see? If any value in the data is less than the input, hide the client?

Re: Take off from table

Anonymous — Mon, 17 Sep 2012 19:08:30 GMT

Yes, If any value in the data less than the input, take the client off from the table.

See attached Captures

Re: Take off from table

Anonymous — Mon, 17 Sep 2012 21:07:06 GMT

Maybe we should work on Dimension level?

Or use flag condition?

Re: Take off from table

Anonymous — Tue, 18 Sep 2012 14:04:29 GMT

???

Re: Take off from table

Tue, 18 Sep 2012 14:05:55 GMT

Here is what I have so far. I got the flag to work, but haven't yet figured out how to make it so that the client is conditional on the flag's result... Hmm.

Re: Take off from table

Anonymous — Tue, 18 Sep 2012 14:19:07 GMT

Thanks for helping me.

My MYear changes dynamically.

Maybe Guru QV are be able to help me.

Regards,