Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Milaf
Contributor III
Contributor III

Set analysis - Valuelist Issue

Hello everyone,

The set analysis I applied does not work with the valulist formula. Is there a different solution? My chart should not be affected by my date filters. 


if(ValueList ('P', 'PD')= 'PD, sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year=, DAY=  >} FCount),
if(ValueList ('P', 'PD') = 'P', SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year=,DAY=  >}FCount)))

 

Thank you.

Labels (1)
7 Replies
anat
Master
Master

can you try using pick and match

pick(match(ValueList ('P', 'PD'),'P','PD'),sum(sal),sum(cost))

Milaf
Contributor III
Contributor III
Author

Hi, than you for response.

I changed the formula according to the format below, I got syntax ok but my chart is not created. I use Barchart, the pick formula does not seem to be suitable.

pick(Match(ValueList ('P', 'PD')= 'PD', 'P', sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year=, DAY=  >} FCount), SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year=,DAY=  >}FCount))

 

Milaf_0-1707975492183.png

 

anat
Master
Master

Can you try below one

pick(Match(ValueList ('P', 'PD'), 'PD', 'P') ,sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year=, DAY=  >} FCount), SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year=,DAY=  >}FCount))

Milaf
Contributor III
Contributor III
Author

Still affected by my YearMonth filter 😞 Interestingly it is not affected by my DAY filter, it works correctly. I must be missing something. 

anat
Master
Master

in set analysis all time filters are bypassed,if want to filter the data based on time filters remove from set analysis

pick(Match(ValueList ('P', 'PD'), 'PD', 'P') ,sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year=, DAY=  >} FCount), SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year=,DAY=  >}FCount))

 

to affect DAY filter use below expression

pick(Match(ValueList ('P', 'PD'), 'PD', 'P') ,sum( {<[BFlag]={"0"},Month= ,YearMonth=, Year= >} FCount), SUM({<[Owner]={'PAEW','OUT'},[BFlag]={"0"}, YearMonth=,Month=,Year=  >}FCount))

Milaf
Contributor III
Contributor III
Author

I think my formula is correct because I am showing 12 months (yearly) in my chart and I don't want it to be affected by any time expression (filters) in my report. Always show 12 months. For this reason, I added my set expressions.

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

 Hi Milaf,

The problem is certainly not related to the ValueList() function. I'd guess that you are using a different field for your YearMonth filter, not the same field as listed in your Set Analysis formula. Double check your filters.

Cheers,