topic Re: Cycle through two expressions at the same time in QlikView

Cycle through two expressions at the same time

rachelpurple — Fri, 01 Jul 2016 13:16:51 GMT

Hi,

I want to have a view for H and Cycle through a view for L. and see for H, how many scheduled and how many proposed. Same I want to see for L.

Currently I am having two cycle through buttons flipping either Scheduled or Proposed. like below:

Original:

Clicked on the first cycle through button:

However, I want only one cycle through button, when clicking, it goes to Scheduled L and Proposed L straight away.

Is there any way to realise this?

Thank you for your help in advance

Colin-Albert — Fri, 01 Jul 2016 16:31:54 GMT

Can you let us know what are the dimensions on your charts, and how you have defined the two cyclic groups?

rachelpurple — Mon, 04 Jul 2016 15:31:22 GMT

Hi Colin,

I only have one Dimension : =if([Proposed Event Date]>=now() and [Proposed Event Date]<43100,[Proposed Event])

Expressions:

Scheduled H: =Count({<H= {"=Event = [Proposed Event]"}>}H)

Scheduled L: =Count({<L= {"=Event = [Proposed Event]"}>}L)

Proposed H: =Count({<H = {"=Len(Trim([Proposed Event]))>0"}>}H)

Proposed L: =Count({<L= {"=Len(Trim([Proposed Event]))>0"}>}L)