Re: Take off from table - Qlik Community

Anonymous · ‎2012-09-14

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,

Report Inappropriate Content · ‎2012-09-14

Here you go.

Anonymous · ‎2012-09-14

Cool!!!

Thanks,

Anonymous · ‎2012-09-14

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,

Anonymous · ‎2012-09-17

Any ideas???

Report Inappropriate Content · ‎2012-09-17

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

Anonymous · ‎2012-09-17

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

See attached Captures

Anonymous · ‎2012-09-17

Maybe we should work on Dimension level?

Or use flag condition?

Anonymous · ‎2012-09-18

???

Report Inappropriate Content · ‎2012-09-18

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.