topic Re: Please kindly assist with the below query ? in App Development

Assistance with Designing Qlik Sense Application to Filter Properly

suvechha_b — Tue, 13 Aug 2019 05:19:45 GMT

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.

Re: Please kindly assist with the below query ?

Josh_Berg_Support — Mon, 12 Aug 2019 14:01:31 GMT

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