topic Re: Something like Custom Groups in Microstrategy in QlikView

Something like Custom Groups in Microstrategy

Mon, 27 Aug 2012 14:01:48 GMT

Hello,

What is my current status:

| Column1 | Column2 |

| 1 | CAT |

| 2 | DOG |

| 3 | DOG |

| 4 | CAT |

| 5 | CAT |

I want to add selection window witch two values: CAT and DOG.

After selecting CAT, only 1, 4 and 5 values should be selected and valid.

Is any easy way to do that?

Kind regards,

Pawel

Re: Something like Custom Groups in Microstrategy

Nicole-Smith — Mon, 27 Aug 2012 14:10:57 GMT

Use a list box.

Re: Something like Custom Groups in Microstrategy

Mon, 27 Aug 2012 14:26:27 GMT

Ok, and now the second scenario:

I've got only one column

| Column1 |

| 1 |

| 2 |

| 3 |

| 4 |

| 5 |

there is no other column (CAT, DOG) with releted value like it was in first scenario. But I want still to make selection window with DOG and CAT values, and after clicking on CAT, only 1, 4 and 5 values should be selected and valid.

More complex, but is any easy way to manage that?

Re: Something like Custom Groups in Microstrategy

Nicole-Smith — Mon, 27 Aug 2012 15:58:01 GMT

You need to link two tables together in the load script in order to get those results.

Re: Something like Custom Groups in Microstrategy

Tue, 28 Aug 2012 08:10:20 GMT

Or I can use If statement

If(Column1 = 1, 'CAT'...) as Something

Anyway. Thanks.