Assistance with Designing Qlik Sense Application to Filter Properly

[suvechha_b]

Hi All ,

How to select the 'Month' and 'Record Souce Name' as '2019-01-01' and '27' resp. to show the chart '1'. ?

In Chart '2' you can see some of the 'Import Month' are null and some of the 'RB_CALENDAR_PERIOD' is null so I put the logic to show '2019-01-01' when null 

=if(ISNULL([Import Month]),RB_CALENDAR_PERIOD,if(ISNULL(RB_CALENDAR_PERIOD),[Import Month],RB_CALENDAR_PERIOD))

same as 'RecordSource' and 'RECORD_SOURCE_GM_ID' when null show 27.

=if(ISNULL(RecordSource),RECORD_SOURCE_GM_ID,if(ISNULL(RECORD_SOURCE_GM_ID),RecordSource,RECORD_SOURCE_GM_ID))

But , it is not working when I am doing selection  as '27'.

My requirement is when I select 'Record Source' as 27 and Import Month as '2019-01-01' then the chart should show like below results -

sample model attached.

[Josh_Berg_Support]

I don't have an immediate answer for your question, however, I would highly recommend you change the title of your thread so others will find it easier.  I would recommend changing it to something like "Assistance with Designing Qlik Sense Application to Filter Properly", or something to that effect.

Based on a quick review, it looks like you don't have the Month field showing the data the way you're expecting it to.  YYYY/DD/MM HH:MM:SS, but you're entering the month as YY/DD/MM without the time.  I deal more with the infrastructure side of things however, this would be one thing I've noticed about what you're doing here.  

When you say "But , it is not working when I am doing selection  as '27'.", can you please elaborate on this?  What does "not working" mean here?

Thanks,
Josh

Qlik Support