topic Re: Conditionally enable a column in straight table using Expressions cyclic group in QlikView

Conditionally enable a column in straight table using Expressions cyclic group

akshayjain90 — Thu, 09 Jun 2016 09:34:15 GMT

Hi All,

I Have a requirement where i need to add a column in a straight table, which would be conditionnaly enabled on the basis of cyclic expression.

For Example - If Product by Sales expression is selected in cyclic group(Expression) then volume should be shown otherwise only rank should be shown.

TOP 6 Product by Sales

Product	Rank	Volume
A	1	60
B	2	50
C	3	40
D	4	30
E	5	20
F	6	10

Top 6 Product by sales of other market

Product	Rank
G	1
H	2
I	3
J	4
K	5
L	6

Can both the tables come under single view using cyclic group(Expression).

Regards,

Akshay

Re: Conditionally enable a column in straight table using Expressions cyclic group

sunny_talwar — Thu, 09 Jun 2016 10:27:18 GMT

I don't think you will be able to determine which cycle expression you are on to enable or disable a column. There might be a macro that can be used, but AFAIK, no inbuilt functionality available to do this

Re: Conditionally enable a column in straight table using Expressions cyclic group

akshayjain90 — Thu, 09 Jun 2016 11:41:27 GMT

Thanks Sunny for your reply.
Is their any other solution for the same?

Re: Conditionally enable a column in straight table using Expressions cyclic group

sunny_talwar — Thu, 09 Jun 2016 12:08:43 GMT

Not that I know of, but may be someone else can help you out

Re: Conditionally enable a column in straight table using Expressions cyclic group

Digvijay_Singh — Thu, 09 Jun 2016 12:16:29 GMT

Can you share your actual dimension and expressions, may be some alternative can be suggested using show/hide in presentation tab or button/action to switch between two views.

Re: Conditionally enable a column in straight table using Expressions cyclic group

trdandamudi — Thu, 09 Jun 2016 12:52:20 GMT

Please take a look at the attached file and see if this is what you are looking for so that you can incorporate this into your dashboard:

Hope this helps...

Re: Conditionally enable a column in straight table using Expressions cyclic group

akshayjain90 — Mon, 13 Jun 2016 06:17:40 GMT

Hi Digvijay,

With the help of button/action I am able to achieve it, but want to know, if expression Cyclic can handle the same or not.

Re: Conditionally enable a column in straight table using Expressions cyclic group

akshayjain90 — Mon, 13 Jun 2016 06:22:59 GMT

Thirumala - I want to show Volume Column and Rank Column both in one cyclic expression and only Rank Column in other cyclic option.

1st cyclic option -

Product	Rank	Volume
A	1	60
B	2	50
C	3	40
D	4	30
E	5	20
F	6	10

2nd cyclic option -

Product	Rank
G	1
H	2
I	3
J	4
K	5
L	6

Re: Conditionally enable a column in straight table using Expressions cyclic group

trdandamudi — Mon, 13 Jun 2016 13:29:57 GMT

Can you take a look at the attached:

Re: Conditionally enable a column in straight table using Expressions cyclic group

akshayjain90 — Mon, 13 Jun 2016 13:34:49 GMT

Hi Thirumala,

This is what i was looking for, can you please share how this was achieved(cyclic for expression).

Re: Conditionally enable a column in straight table using Expressions cyclic group

trdandamudi — Mon, 13 Jun 2016 14:27:04 GMT

Please see the attached word file along with the screen shots and hope this helps... Also if you think you got your answer can you please close the thread by marking correct answer appropriately.

Re: Conditionally enable a column in straight table using Expressions cyclic group

akshayjain90 — Tue, 14 Jun 2016 06:25:30 GMT

Hi Thirumala,

Thanks for all the help.

But I want the same functionality without adding any new column(Product by sales or Product by Rank).

Can we achieve the same without using extra column.

Akshay

Re: Conditionally enable a column in straight table using Expressions cyclic group

trdandamudi — Tue, 14 Jun 2016 09:13:33 GMT

You cannot avoid the column but you can make it blank without showing Product by Sales /Product by Rank. See if the attached is acceptable:

Re: Conditionally enable a column in straight table using Expressions cyclic group

akshayjain90 — Tue, 14 Jun 2016 10:04:50 GMT

No, we cant keep the blank column.

Re: Conditionally enable a column in straight table using Expressions cyclic group

trdandamudi — Tue, 14 Jun 2016 10:47:53 GMT

Ok. Then you can use the list box for the selection and it will get rid off the extra column. See attached: