Qlik Community

Qlik Sense Cloud Discussions

bohemia_group
New Contributor

Dimension as a function of filter

Hi,

apologies if this question was raised/answered elsewhere. Did not find it by googling.

Setup:

1) Filter (acting as a drop down) with possible options:

SEL1

- Month

- Week

- Dat

2) 2x charts which have dimensions setup as a function of SEL1:

= if(SEL1 = "Month", date.Month, date.Day)

where date.Month and date.Day are 2 separate variables/columns with Month and Day respectively.

Problem:

I get an error "cyclical link" and an app essentially freezes.

Question:

Is there any way how to implements conditional dimension in Qlik Sense Cloud?

Any ideas how to implement it in Qlik Sense Cloud would be highly appreciated!

Warm regards,

  Alex

P.S. Let's please ignore the cases when multiple values are chosen in SEL1.

3 Replies

Re: Dimension as a function of filter

May be try with single quotes

=If(SEL1 = 'Month', date.Month, date.Day)

bohemia_group
New Contributor

Re: Dimension as a function of filter

Hi Sunny,

thank you very much, that actually worked.

May I ask you what I have missed?

Where should I read about the difference between single and double quotes?

Warm regards,

  Alex

PS How do I mark your answer as "correct"?
So far I saw only "helpful"...

Re: Dimension as a function of filter

Double quotes are used for field names and singles quotes are for search string. See more here

QlikView Quoteology

For marking correct and helpful responses, check here

Qlik Community Tip: Marking Replies as Correct or Helpful

Community Browser