Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
shwethaa
New Contributor III

Set expression passing island date field in table expression

I have island Calendar table.

I have pulled island date week in the straight table. so in measure I want to pass sum of sales where main date week=island date week.

 

4 Replies
Partner
Partner

Re: Set expression passing island date field in table expression

Try

 

date week=P(island date week)

Re: Set expression passing island date field in table expression

You might need to use if statement here

shwethaa
New Contributor III

Re: Set expression passing island date field in table expression

No if statement doesn't work, because dimension in the table is Island date field, so I want to show data related original date in front of this island field.

 

Re: Set expression passing island date field in table expression

Would you be able to share a sample where we can see the issue?