Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
christiancut
Contributor
Contributor

set analysis: how to ignore date filter on chart label

Hi,

I have a problem with x axes label in chart.

I have a chart with month in x axes and value in y axes.

I have used following expression to exclude data filters 

Avg({1<[MarketName]={'MGP'},[ZoneCode]={'PUN'}, [Date]=>}Val_18)

The expression work correctly but, in the chart label, I have the correct name only for month filtered

148b7eef9f5f4d6fa7457e1e257d0460.png

There's a solution for my problem?

 

Thanks

 

3 Replies
vikasmahajan

Avg({$<   DateField= ,      [MarketName]={'MGP'},[ZoneCode]={'PUN'}, [Date]=>}Val_18)

 

This will ignore date field in set analysis

 

HTH

 

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
christiancut
Contributor
Contributor
Author

Hi Vikas,

I have no problem with calculation.

The value shown in chart is correct. The problem is only the laber of x-axes where I see the month's name only for the months filtered and not for all.

vikasmahajan

Can you attach sample demo

 

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.