topic Re: how to use variable values in Dimension in QlikView

how to use variable values in Dimension

Tue, 03 Jun 2014 08:00:52 GMT

Dear all,

I have created 4 variable in my qlikview viz

vFromDate1= 1/1/2013, vToDate1= 25/1/2013

vFromDate2=1/1/2014, vToDate2= 30/1/2014,

User can change the values on the dashboard, to analyse by 2 different date range.

I want to use graph showing Week and Month as Dimension and

=num(Sum({$<[GL Posting Date]={'>=$(vFromDate1) <=$(vToDate1)'}>} [Debit Amount]), '#,##0') and

=num(Sum({$<[GL Posting Date]={'>=$(vFromDate2) <=$(vToDate2)'}>} [Debit Amount]), '#,##0')

as Expression.

Expressions are working perfect, But I want to put condition over Dimension that, only show the weeks or months ranging in variable, or set in variable.

I am clicking 'Enable Conditional' at Dimention tab and typing this statement, which is not working Please help

Week(Week='>=$(vFromDate1) <=$(vToDate1) and '>=$(vFromDate2) <=$(vToDate2))

Re: how to use variable values in Dimension

Gysbert_Wassenaar — Tue, 03 Jun 2014 08:06:41 GMT

The Enable Conditional option is to show or hide the dimension completely. If that's what you're trying to do can you explain the conditions? When should the week dimension be shown and when not? Same for the month dimension.

Re: how to use variable values in Dimension

Tue, 03 Jun 2014 08:08:58 GMT

Hi Vivian

use calculatred dimension as

if ( (Week='>=$(vFromDate1) <=$(vToDate1) and '>=$(vFromDate2) <=$(vToDate2)), Week)

chris

Re: how to use variable values in Dimension

Tue, 03 Jun 2014 08:21:03 GMT

Hi, gwassenaar,

Please give me your Email add, I think If you see the dashboard, it will be more understandable

Re: how to use variable values in Dimension

Tue, 03 Jun 2014 08:22:13 GMT

HI christianj,

Thanks for the reply

Its not working, Please give me your Email, better you see the dashboard

thanks

Re: how to use variable values in Dimension

Gysbert_Wassenaar — Tue, 03 Jun 2014 08:25:27 GMT

Create a small sample document instead like explained in this document: Preparing examples for Upload - Reduction and Data Scrambling

Re: how to use variable values in Dimension

Tue, 03 Jun 2014 09:02:09 GMT

When I count Debit Amount for First period i use this,

=num(Sum({$<[GL Posting Date]={'>=$(vFromDate1) <=$(vToDate1)'}>} [Debit Amount]), '#,##0')

Re: how to use variable values in Dimension

Mon, 28 Jul 2014 10:11:41 GMT

Did you find the solution?

I have the same issue.

Thanks!