Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ersanduran
New Contributor III

Re: Using Alternate State in QLikSense (without Extensions)

Hi Onur

I am not able to see the attachment, could you please add one more time?

Regards

Ersan

Not applicable

Re: Using Alternate State in QLikSense (without Extensions)

Attached Again

ersanduran
New Contributor III

Re: Using Alternate State in QLikSense (without Extensions)

Hi Onur

Thanks a lot for sharing the app. Now I see what is wrong. You integrated your selection tables to your data model. Data island means that you create tables for your selections but you will not associate them to your data model. In this case any selection you make on one of those selection table will not have any affect on your associative model and you will use set analysis to reflect your selection in your associative model.

So what you need to do is:

1. keep only Date B field in DetailB and Date A field in DetailA tables (remove other 2 fields)

2. load the data and confirm that there is no association between those 3 tables in the picture.

3. In front end update your formulas as follows:

Date A Total: Sum({$<Date=P([Date A])>}[Count])

Date B Total: Sum({$<Date=P([Date B])>}[Count])

The set analysis statement "Date=P([Date A])" here means that filter Count values only to Date values where Dates values are in one of the selected "Date A" values. In other words using set analysis you build the association between your selection and your data (in your case Summary table)


Please let me know if this is clear.


Regards

Ersan

Capture.PNG

silvacarlos
Contributor II

Re: Using Alternate State in QLikSense (without Extensions)

This is really helpful, thanks!

Not applicable

Re: Using Alternate State in QLikSense (without Extensions)

‌Hello Ersan,

thanks for the information. It was really helpful.

sogloqlik
New Contributor II

Re: Using Alternate State in QLikSense (without Extensions)

Great Solution, much better than the extention

supriyaranganat
New Contributor III

Re: Using Alternate State in QLikSense (without Extensions)

I was looking for a solution for so long.. Thank you so much... It worked... ersan.duran

Highlighted
ersanduran
New Contributor III

Re: Using Alternate State in QLikSense (without Extensions)

I am glad to be able to help.

vkish16161
Contributor III

Re: Using Alternate State in QLikSense (without Extensions)

All,

This feature is now available in Qlik Cloud.

Alternate states QS 2.JPG

NewToQlik
New Contributor III

Re: Using Alternate State in QLikSense (without Extensions)

I noticed that in the example, the 'CalendarYear' filter pane allows u to select a year, even with no data. Is it possible to have some indications, eg. darken the colour of years with no data in the filter pane?