topic Re: Filtering chart table in QlikView

Filtering chart table

Anonymous — Wed, 08 Jul 2015 03:42:54 GMT

Hello friends of QV,

i have a chart table where I have a column (Status) that shows "UP" or "DOWN" using a simple logic (If col A > col B, "UP", "DOWN").

Is there a way i can now have a listbox containing the word "UP" and "DOWN" so that when i click on it, the chart table should then only show all values where column Status = "UP" or only values where column = "DOWN". Any ideas much appreciated.

This is how i am currently displaying the table.

Customer	Current Year	Last year	Status
A	100	50	UP
B	200	500	DOWN
C	300	500	DOWN
D	400	300	UP

however, current Year and Last Year columns are calculated; so depending on what period is selected, the Current Year and Last Year will change. Hence, the status column is also dynamic.

thanks in advance

Derrell

Re: Filtering chart table

Siva_Sankar — Wed, 08 Jul 2015 03:48:08 GMT

Derrell, You can do that by using the expression in the listbox with same formula as mentioned by you. find the attached document working example with your data.

Re: Filtering chart table

jagan — Wed, 08 Jul 2015 03:54:36 GMT

Hi,

Try like this in script, you need to arrive a new column in script like below

LOAD

If(ColA > ColB, 'UP', 'DOWN') AS Status

FROM DataSource;

Now use Status field as listbox to filter the data.

Hope this helps you.

Regards,

Jagan.

Re: Filtering chart table

Anonymous — Wed, 08 Jul 2015 04:11:29 GMT

Thanks Jagan

good ideas.

But i think i should have been more detail in my example.my bad.

This is how i am currently displaying the table.

Customer	Current Year	Last year	Status
A	100	50	UP
B	200	500	DOWN
C	300	500	DOWN
D	400	300	UP

however, current Year and Last Year columns are calculated; so depending on what period is selected, the Current Year and Last Year will change. Hence, the status column is also dynamic.

sorry for the poor initial explanation of my problem.

Re: Filtering chart table

Anonymous — Wed, 08 Jul 2015 04:11:55 GMT

Thanks Shankarece

good ideas.

But i think i should have been more detail in my example.my bad.

This is how i am currently displaying the table.

Customer	Current Year	Last year	Status
A	100	50	UP
B	200	500	DOWN
C	300	500	DOWN
D	400	300	UP

however, current Year and Last Year columns are calculated; so depending on what period is selected, the Current Year and Last Year will change. Hence, the status column is also dynamic.

sorry for the poor initial explanation of my problem.

regards

Derrell

Re: Filtering chart table

jagan — Wed, 08 Jul 2015 04:13:46 GMT

Hi,

Then create and Island table like below, it should not link with your data model

Status:

LOAD

INLINE [

Status

DOWN];

Now in the front end provide this as filter. Alter you expression to display accordingly. If you attach a sample file then it would be easier to provide the solution.

In the expression try like this

If(ColA > ColB AND Concat(Status, ',') LIKE '*UP*', 'UP',

If(ColA <= ColB AND Concat(Status, ',') LIKE '*DOWN*', 'DOWN'))

Hope this helps you.

Regards,

Jagan.

Re: Filtering chart table

Anonymous — Wed, 08 Jul 2015 04:48:45 GMT

Hi Jagan,

here is the sample file

Re: Filtering chart table

Wed, 08 Jul 2015 05:14:28 GMT

Hi ,

Please find the attached QVW.

Re: Filtering chart table

Anonymous — Wed, 08 Jul 2015 05:22:42 GMT

thanks, Reshma.

it works.

however, have a look at my replies to the team on some added complexity

i've attached a sample file for Jagan.

regards

Derrell

Re: Filtering chart table

jagan — Wed, 08 Jul 2015 06:38:30 GMT

Hi Derrell,

Please find attached file for solution.

Regards,

Jagan.

Re: Filtering chart table

Anonymous — Wed, 08 Jul 2015 06:41:35 GMT

Hello,

PFA.

Re: Filtering chart table

Anonymous — Wed, 08 Jul 2015 07:06:36 GMT

Thank you Ravichandra! much appreciated

Re: Filtering chart table

Wed, 08 Jul 2015 07:11:41 GMT

Hi Derrell ,

Based On u r Qvw i have tried smthing i think it might help u..

attaching u r updating qvw also

Re: Filtering chart table

qlikviewwizard — Wed, 08 Jul 2015 07:11:55 GMT

Hi jagan

Thank you Jagan. It is perfect.

Re: Filtering chart table

jagan — Wed, 08 Jul 2015 07:12:57 GMT

Hi Derrell,

I am not sure why are you using 3 expressions for Status instead of using single expression. Did you checked the file which I attached?

Regards,

jagan.

Re: Filtering chart table

Wed, 08 Jul 2015 07:39:21 GMT

Hi jagan ..it's really nice answer..i have learnt concat like super