table in qliksense

yogitamehta10 — Fri, 26 Aug 2016 10:41:46 GMT

i have table in qliksense have 10 dimensions and one measure .

now i have a filter like list box on dashboard that have month filter , now i want my report to show by defualt current month data and based upon the filter it will get change

Re: table in qliksense

Anonymous — Fri, 26 Aug 2016 10:53:27 GMT

I think you can for set analysis like this for showing current month

Assuming your 'Month' is in 'MMM-YYYY' format ..........

Sum({$<[Month]={"$(=Date(Max(Month), 'MMM-YYYY'))"}>} Measure )

Re: table in qliksense

Michael_Tarallo — Fri, 26 Aug 2016 18:22:42 GMT

Hello Yogita,

This can be achieved with a combination of conditional expressions and Set Analysis.

click to enlarge

See sample app attached. (qvf file) Note that the August (this month) value in the table matches the value in the KPI object, when I select another month the KPI updates to show that month.

Note - I used the Set Analysis Expression - with $ expansion: (known as dollar expansion)

if(getselectedcount([OrderDate.autoCalendar.Month]) = 0,
Sum({$<[OrderDate.autoCalendar.Month]={"$(=Month(Today()))"}>} Sales),Sum(Sales))

for you:

if(getselectedcount([yourMonthField]) = 0,
Sum({$<[yourMonthField]={"$(=Month(Today()))"}>} yourMeasure),Sum(yourMeasure))

give it a try and let us know how you do.

You may want to explore Set analysis as our Qlik Community member has mentioned.

You can learn more here: A Beginners' Introduction to Set Analysis (video)

from this video index: New to Qlik Sense Videos

Please copy .qvf file to your C:\Users\<user profile>\Documents\Qlik\Sense\Apps and refresh Qlik Sense Desktop with F5

(if using Desktop)

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

topic table in qliksense in QlikView

table in qliksense

Re: table in qliksense

Re: table in qliksense