topic Re: Selection Yes/No in QlikView

Selection Yes/No

rolandg1881 — Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I have a Sales Report in Qlikview, the most things are done but im not able to find a solution for a "easy" problem.

I can Report the revenue für the calender year and the fiscal year and now i ned a Selection for Example Fiscal Year: Yes/No where the user can choose this.

If he says yes he can see only the Fiscal Year Data and when its no than he can see the calender year data.

I only need an example how i can make the selection field with yes/no.

Sorry for my bad english! 😉

greetings Roland

Re: Selection Yes/No

rolandg1881 — Thu, 03 Oct 2019 07:29:54 GMT

Hello again!

I have a solution. I create an Excel Sheet with Periode: Calender Year and Financial Year

Then i "import" it in the Qlik Report an make a Multibox where the user can can choose Calender or Financial Year.

So i can report only the relecant data.

Good solution or not? I dont know but it works.

Greetings Roland

Re: Selection Yes/No

Arthur_Fong — Thu, 03 Oct 2019 07:30:49 GMT

Why not use buttons instead of selections?
Create a new variable eg: vYear
In buttons > create trigger to toggle value in the variable
eg: if vYear=1,'Fiscal Year','Calendar Year'
Update all charts and expression with this new variable.

Re: Selection Yes/No

Marnus_Bosch — Thu, 03 Oct 2019 08:00:29 GMT

Hi,

A good way of solving this issue is to use a button (as previously mentioned) that changes the value of a variable. Let's call this variable vCalendarType.

When the user clicks either button it changes the value of this variable. Let us then also assume, that when the user selects the Calendar Year button, the value of vCalendarType = 1 else it is 2 (Fiscal Year).

Then using the value of this variable, you can use the pick and match functions to alternate between set analysis expressions, normally I would have these in variables too.

For example:

Sales for Calender year = vSalesCalendarYr

Sales for Fiscal year = vSalesFiscalYr

Then these variables are populated with a set analysis expression such as:

vSalesCalendarYr = Sum({$<CalendarYear={2019}>}Sales)
vSalesFiscalYr = Sum({$<FiscalYear={2019}>}Sales)

Then in your expression field would look something like this:

pick(match(vCalendarType,1,2),vSalesCalendarYr,vSalesFiscalYr)

Sorry, I didnt actuall write these expressins in the tool, so there might be (but hopefully aren't) syntax errors 😉

Hope that helps and good luck.

Re: Selection Yes/No

Yevhenii_Senko — Thu, 03 Oct 2019 12:20:28 GMT

Based on a data model and requirements could be implemented different solutions.

I would use mentioned variables as toggle button and Conditional show in Objects/Expressions.

Re: Selection Yes/No

Marnus_Bosch — Sun, 06 Oct 2019 20:39:18 GMT

Hi Roland,

Did you manage to resolve your problem?

Re: Selection Yes/No

Brett_Bleess — Wed, 09 Oct 2019 21:46:38 GMT

Hey Roland, here is the base URL to the Design Blog area where you will find a lot of how-to posts. I checked, really nothing I could find that fits your specific situation, but I wanted to pass along in case it may come in handy in the future, I am sure it will be good to give you some ideas on how to approach things at least. I am going to mark your other post as the solution on this one too, if you do end up using one of the other posts to do something different, feel free to use the Accept as Solution button on that post as well to let folks know that worked too and to give the poster credit.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett