topic Re: Problem with showing data based on data entry (input box) in QlikView

Problem with showing data based on data entry (input box)

Fri, 21 Aug 2015 10:05:57 GMT

Hi i have a question,

i want to show the data based on user entry, i want to show all data if user doesnt input any data. When user input the data, it will show the data based on the entry.

I'm using this expression

if($(=len(percenFrom))=0 or $(=len(percenTo))=0,'A', 'B')

it works perfectly, but when i change the result A and B to another 'if condition' it doesnt show any data when im not enter the data. but when i enter the data it works perfectly.

Really appreciate your help, thanks

Re: Problem with showing data based on data entry (input box)

sunny_talwar — Fri, 21 Aug 2015 10:08:51 GMT

May be you need to check your second if condition if the one you have posted here is working as expected. Can you share the complete expression here?

Re: Problem with showing data based on data entry (input box)

Fri, 21 Aug 2015 10:15:12 GMT

=if($(=len(percenFrom))=0 or$(=len(percenTo))=0,

if(IsNull(vYear)

if(isnull(vWeek),

Sum({$<TRX={1}>} QTY),

Sum({$<TRX={1}, YearWeek={$(vWeek)}>} QTY)

if(isnull(vWeek),

Sum({$<TRX={121}, Year={$(vYear)}>} QTY) ,

Sum({$<TRX={121}, YearWeek={$(vWeek)}, Year={$(vYear)}>} QTY)

)

.....

)

the first condition will show all data if user doesnt entry the input box (percenfrom/percento)

Re: Problem with showing data based on data entry (input box)

sunny_talwar — Fri, 21 Aug 2015 10:17:16 GMT

Not sure if this is the exact expression copy pasted from source or if it is just a typo, but a comma seems to be missing. See if that helps.

Indra Setiana wrote:

=if($(=len(percenFrom))=0 or$(=len(percenTo))=0,

if(IsNull(vYear) //Comma missing here

if(isnull(vWeek),

Sum({$<TRX={1}>} QTY),

Sum({$<TRX={1}, YearWeek={$(vWeek)}>} QTY)

),

if(isnull(vWeek),

Sum({$<TRX={121}, Year={$(vYear)}>} QTY) ,

Sum({$<TRX={121}, YearWeek={$(vWeek)}, Year={$(vYear)}>} QTY)

)

),

.....

.....

)

the first condition will show all data if user doesnt entry the input box (percenfrom/percento)

Re: Problem with showing data based on data entry (input box)

Fri, 21 Aug 2015 10:21:25 GMT

Dear Sunny,

oops sorry, it's just a typo, the source expression has comma, but it still not working,

Do you have any idea, confuse about it.

Re: Problem with showing data based on data entry (input box)

sunny_talwar — Fri, 21 Aug 2015 10:24:46 GMT

Try this may be:

if($(=len(percenFrom))=0 or$(=len(percenTo))=0,

if(Len(Trim(vYear)) = 0,

if(Len(Trim(vWeek)) = 0,

Sum({$<TRX={1}>} QTY),

Sum({$<TRX={1}, YearWeek={"$(vWeek)"}>} QTY)

if(Len(Trim(vWeek)) = 0,

Sum({$<TRX={121}, Year={"$(vYear)"}>} QTY) ,

Sum({$<TRX={121}, YearWeek={"$(vWeek)"}, Year={"$(vYear)"}>} QTY))),

Re: Problem with showing data based on data entry (input box)

Fri, 21 Aug 2015 10:31:51 GMT

Dear Sunny,

Thanks for your response Sunny, but it still not working

do you have another idea ?

thanks

Re: Problem with showing data based on data entry (input box)

sunny_talwar — Fri, 21 Aug 2015 10:34:27 GMT

Can you test if individually each of the expression is working or not. These

1) Sum({$<TRX={1}>} QTY)

2) Sum({$<TRX={1}, YearWeek={"$(vWeek)"}>} QTY)

3) Sum({$<TRX={121}, Year={"$(vYear)"}>} QTY)

4) Sum({$<TRX={121}, YearWeek={"$(vWeek)"}, Year={"$(vYear)"}>} QTY)

Re: Problem with showing data based on data entry (input box)

Fri, 21 Aug 2015 10:37:11 GMT

Hi Sunny,

all of the statement works perfectly Sunny, no problem with the statement.

Re: Problem with showing data based on data entry (input box)

sasiparupudi1 — Fri, 21 Aug 2015 10:46:36 GMT

please try the following expressions ina text object and see if they return any values

if(IsNull(vYear)and isnull(vWeek),Sum({$<TRX={1}>} QTY),if(IsNull(vYear)and not isnull(vWeek),Sum({$<TRX={1}, YearWeek={$(vWeek)}>} QTY) ,0)

if(isnull(vWeek),

Sum({$<TRX={121}, Year={$(vYear)}>} QTY) ,

Sum({$<TRX={121}, YearWeek={$(vWeek)}, Year={$(vYear)}>} QTY)

hth

Sasi

Re: Problem with showing data based on data entry (input box)

Fri, 21 Aug 2015 10:56:25 GMT

Dear Sasidhar,

Hi, i have try both condition, both statement return value perfectly.

Really confuse about it

Re: Problem with showing data based on data entry (input box)

sasiparupudi1 — Fri, 21 Aug 2015 11:38:05 GMT

try changing the if condition

if(len('$(percenFrom)')=0 or len('$(percenTo)')=0,'A', 'B')

if that does not work, just hardcode the values and see if the if condition works fine

hth

Sasi

Re: Problem with showing data based on data entry (input box)

Kushal_Chawda — Fri, 21 Aug 2015 11:56:28 GMT

try this,

if(len(trim(percenFrom))=0 or len(trim(percenTo))=0,

if(Len(Trim($(vYear))) = 0 and Len(Trim($(vWeek))) = 0,

Sum({$<TRX={1}>} QTY),

Sum({$<TRX={1}, YearWeek={"$(vWeek)"}>} QTY)),

if(Len(Trim($(vWeek))) = 0,

Sum({$<TRX={121}, Year={"$(vYear)"}>} QTY) ,

Sum({$<TRX={121}, YearWeek={"$(vWeek)"}, Year={"$(vYear)"}>} QTY)))

Re: Problem with showing data based on data entry (input box)

Mon, 24 Aug 2015 01:28:28 GMT

Hi Sasidhar,

sorry for late reply, i've changed the if condition, but still not working.

do you have any idea ?

thanks

Re: Problem with showing data based on data entry (input box)

Mon, 24 Aug 2015 01:29:11 GMT

Hi Kush,

Sorry for late reply,

i've try your suggestion, but still not working,

do you have any idea ?

thanks