Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

akshayjain90
New Contributor II

Conditionally enable a column in straight table using Expressions cyclic group

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

ProductRankVolume
A160
B250
C340
D430
E520
F610

Top 6 Product by sales of other market

ProductRank
G1
H2
I3
J4
K5
L6

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

Regards,

Akshay

14 Replies
Highlighted

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

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

Highlighted
akshayjain90
New Contributor II

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

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

Highlighted

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

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

Highlighted
Digvijay_Singh
Honored Contributor III

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

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.

Highlighted
trdandamudi
Honored Contributor II

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

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...

Cyclic_Expression_ScreenShot.jpg

Highlighted
akshayjain90
New Contributor II

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

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.

Highlighted
akshayjain90
New Contributor II

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

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 -

ProductRankVolume
A160
B250
C340
D430
E520
F610

2nd cyclic option -

ProductRank
G1
H2
I3
J4
K5
L6

Highlighted
trdandamudi
Honored Contributor II

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

Show_Column_Based_On.jpgCan you take a look at the attached:

Highlighted
akshayjain90
New Contributor II

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

Hi Thirumala,

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